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