HI, If this works to find a word within a cell =ISNUMBER(SEARCH(C1,Sheet2!C$1)) Why doesnt this =ISNUMBER(SEARCH(C1,Sheet2!C:D,2)) to find a word from within a range of cells, and return back a word from the 2nd column? Many thanks.
Solved by A. H. in 15 mins