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.