Posted to microsoft.public.excel.worksheet.functions
|
|
Need help with Excel 2000 text-related functions
=IF(B16="OFF","",IF(ISNA(VLOOKUP(A1,C3:C14,1,0)),A 1,""))
--
David Biddulph
"Joan A" wrote in message
...
Thanks, this worked!
But now, I'm wondering if I can add another IF in the same cell. I only
want the first formula to run if the value in another cell equals
something.
For instance, if B16<OFF, then run
=IF(ISNA(VLOOKUP(A1,C3:C14,1,0)),A1,"").
Or if it does equal OFF, then a blank cell overrides the formula you
provided.
Clear as mud?
"Tyro" wrote:
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?
|