Modify formula to check if value exists in a different worksheet

I'm currently using the following formula to check if the contents of cell A exist in any of the cells in column A from the worksheet 'ahrefs' and return a Yes or a No accordingly.

=IF(ISNA(MATCH(A2,ahrefs!$A$2:$A$50000,0)),"No","Yes")

I wish to also check if the value exists in column A of worksheet 'wmt' but am unsure how to modify the above formula to include an OR statement that includes the additional sheet. Please could someone advise? Thanks in advance.

Originally Posted by Tony Valko

One way...

=IF(COUNT(MATCH(A2,ahrefs!$A$2:$A$50000,0),MATCH(A2,wmt!$A$2:$A$50000,0)),"Yes","No")

Perfecto.

Thanks very much Tony, that did the job nicely.