Hi all
I have two lists in excel, first is ~3000 numbers, second is ~20,000 numbers. What I need to do is compare whether each number in list 1 exists on list 2.
I tried:
=IF(Sheet1!A1:A10=Sheet2!A1:A10,"Yes","No")
However this only works where the number is in the same cell on both sheets, effectively ruling it pointless.
Thanks for any help, Greboth.
Edit: Nevermind, found a vlookup formula to do it
I have two lists in excel, first is ~3000 numbers, second is ~20,000 numbers. What I need to do is compare whether each number in list 1 exists on list 2.
I tried:
=IF(Sheet1!A1:A10=Sheet2!A1:A10,"Yes","No")
However this only works where the number is in the same cell on both sheets, effectively ruling it pointless.
Thanks for any help, Greboth.
Edit: Nevermind, found a vlookup formula to do it
Last edited: