Assuming A1 contains the name you are looking for put this formula in C18

=IF(ISNA(VLOOKUP(A1,C3:C14,1,0)),A1,"")

Tyro

"Joan A" <Joan wrote in message
...
How do I search a range of text cells and return value(s) based on my
findings?

From C18, I want to search C3:C14, said cells sometimes containing names,
to
see if one particular name is there. If it is, I want to leave C18 blank.
If it isn't, I want to insert the name in C18.

I've tried IF multiple ways and it either returns "FALSE" or "#VALUE!".

Help?