TB's Code Library
If it ain't tight, it ain't right!
Search
Friday, August 30, 2013
Excel - Search Cell for Matching Value
Excel Formula to search a cell's contents for the value within quotes and determine if it contains a match. If True, it returns the cell's contents. If False, it leaves it blank.
=IF(ISNUMBER(SEARCH("Ticket",A2)),A2,"")
Newer Post
Older Post
Home