Unwanted LOOKUP() Result

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

[KL]

Hi,

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

Regards,
KL


"Sympatico News" <[email protected]> wrote in message
news:[email protected]...
>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","")
>
>