Sorry for the vague subject line. Not enough space to explain in detail.
I have a large Excel file and a small Excel file. The main column I'm watching is a column for inventory ID numbers (SKUs). I want to identify the SKUs from the large file that are also in the small file. I could do it manually but that takes a long time. Is there a fast way to go through the large file and flag the lines that are also in the small file?
Thanks!!
Donut Tim
Favorite Answer
Put the following formula in the next column to the long list column. It assumes the short list begins in column A and the long list begins in column E:
=COUNTIF($A$1:$A$25,E1)
Copy it down the long list column. It returns a total of the numbers in the short list that match the number in the long list in the adjacent cell.
. .
dmcbeth@rogers.com
In the large file..........create a blank column.............
Use the VLOOKUP function/formula to check for SKUs of the large file that exist in the Small file.
Those that do not exist in the small file will return #N/A