VLOOKUP or/and MATCH Function

Welcome to the Forum!

First let's get terminology straight--everybody says "spreadsheet" but an Excel file is a workbook and contains multiple worksheets. Do you have one file or two files?

If you have one file with two sheets (selected by tabs) called Sheet1 and Sheet2 respectively, you can take the following steps:

1. In Sheet1 insert a header row that gives titles for each of the two columns (I'm assuming A and B).
2. Add a third column called Missing in C
3. Under the third column, put this formula in C2:
   
   Formula:

   Please Login or Register  to view this content.

   
   and copy it down for all the rows that have data
4. Click on A1
5. Click on Data, Autofilter (I no longer have Excel 2003 so I don't remember the exact menu sequence to turn on Autofilter)
6. Click on the filter arrow in C1 and unselect Select All and then select "NOT FOUND" and the result is a list of the 400 that are missing from the second list.

I can't reconcile your screenshot with what you just said. It looks like you filtered for NOT FOUND and so only the NOT FOUND rows are being displayed.

Don't attach a screenshot of your Excel file--just attach the file! It's easier than taking a screenshot first and then attaching that.