matching formula

[Guest]

I want to check a column to see if data there is on another worksheet. I
have the formula below which works but returns N/A if there is no match. How
do I get it to return yes if there is a match and no if there is not ?

Thanks

Todd

=IF(MATCH(C5,'Tracking Sheet'!E$2:E$3000,0),"yes","no")

 

[Guest]

Try:

=IF(ISNA(MATCH(C5,'Tracking Sheet'!E2:E39,0)),"no","yes")

HTH

Ian

 

[Guest]

SHould be:

=IF(ISNA(MATCH(C5,'Tracking Sheet'!E2:E3000,0)),"no","yes")