Need help with Excel 2000 text-related functions
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?
|