Unwanted LOOKUP() Result

S

Sympatico News

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","")
 
K

KL

Hi,

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

Regards,
KL
 
Top