If Sheet1, A2 equals Sheet2, H:H, return Yes, No

Question

If Sheet1, A2 equals Sheet2, H:H, return Yes, No

Emily A 40

Seems simple enough. If the email in Sheet1, Column A, Row 2 matches anywhere in Sheet2, Column H, then return Yes; if not, return No. There are no headers in Sheet 2 as I removed them thinking that may have been the issue.

I've tried these formulas with no luck. =If(A2='Sheet2'!H:H,"Yes","No") and receive Spill Range too large error

=NOT(ISERROR(MATCH(A2,'Sheet2'!H:H,0))) and nothing is returned; it's like it doesn't recognize it as a formula.

=IF(ISNUMBER(MATCH(A2,'Fire Call Out'!H:H,0),YES,No)) and receive too many arguments error.

I appreciate your help with this!

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Hendrix-C 20,020 Microsoft External Staff Moderator

Hi @Emily A,

Thank you for reaching out to Microsoft Q&A Community.
According to your sharing, we suggest you can try this formula:
=IF(COUNTIF(Sheet2!H:H, A2) > 0, "Yes", "No")
It will count how many times the value in A2 appears in column H of Sheet2.If the count is greater than 0, it means there's a match, so it returns "Yes". Otherwise, it returns "No".

I hope the above information is helpful for you. If there's anything else I can help you with, please feel free to reach out again.

Looking forward to your response.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment”.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Emily A 40 Reputation points

2025-09-16T22:03:18.8966667+00:00

This worked after I recreated the spreadsheet. Somehow the original spreadsheet was corrupted, but this absolutely worked in the new one. Thank you so much! Saved me a few hours of work for sure!