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