IF and vlookup to display non found entries

[Paul Naylor]

HI Hoping someone can help?

Using the following formula to identify if an item doesn't appear on a subsequent sheet:

=IF(T2="Y", VLOOKUP($C2,Sun!$C:$D,1,False))

Rather than displaying error #N/A if T2="Y" and not found on Sun! Sheet' want to display "N" if T2 ="Y" & found on Sun! Sheet, "Y" if T2="Y" & non found on Sun! Sheet or "N/A" , if T2="N"

 

[Paul Naylor]

forgot to mention work still using excel 97

 

[Fluff]

How about

=IF(T2<>"Y","N/A",IF(ISNUMBER(MATCH($C2,sun!C1:C1000,0)),"N","Y"))

 

[Paul Naylor]

That's great , works a treat !, just needed to amend formula to encompass full column $C:$C, couldn't have done it without you

 

[Fluff]

You're welcome & thanks for the feedback.