Excel Formula Question

[BankBob]

This is probably an easy solve, but I am a bit stumped and have tried using @if, @match type formulas and keep getting "N/A"... I have 2 tabs in excel. The first tab has over 15,000 rows of data. The 2nd tab has about 2,000 rows of data. I want to see if the account # in tab 1 is also on tab 2. I thought there has to be a way to do an @if that says if the account in cell A5 is also someone in tab 2 (in the 2,000 + rows), then put a "Y" in the next column and if the account is nowhere to be found on the 2nd tab, then put a "N" in the next column.... Hope that makes sense and hope someone has an idea or solution for me.

Thank you & have a great weekend!

Bob

 

[Joe4]

Welcome to the Board!

One easy solution to use is a COUNTIF. So you count how many times a particular value occurs on your second sheet. If it is greater then 0, then you have a match, i.e.

=IF(COUNTIF([I]range, value[/I])>0,"Y","N")

Here is a write-up on using COUNTIF: https://www.techonthenet.com/excel/formulas/countif.php