Unwanted LOOKUP() Result
 

I want to avoid getting "N/A" as a result when there is no match on the
formula below. What I need is a blank on no match but an "S" when it does.

How do we do this? Thought this would work.....

=IF(LOOKUP(A3,!$H14:$H27)=A3,"S","")

Hi,

Why don't you have a look at your recent identical post in
'microsoft.public.excel' NG?

Regards,
KL


"Sympatico News" wrote in message
...
I want to avoid getting "N/A" as a result when there is no match on the
formula below. What I need is a blank on no match but an "S" when it does.

How do we do this? Thought this would work.....

=IF(LOOKUP(A3,!$H14:$H27)=A3,"S","")