View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joan A Joan A is offline
external usenet poster
 
Posts: 1
Default 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?