Hi,

I have 2 different Excel files with data. There are Numbers in Column 1 in
both files, and names in Column 2. Other then writing VB script or buying a
third party product is there an easier way to:

Check to see what numbers in File 1 are not in File 2.

If not, I can copy past the worksheet into the same file to have 2
worksheets in 1 file. If I do this, what would the formula be to check this
and then output the numbers that are missing in column 1 between the 2
worksheets. To get fancy what if I wanted it to then tell me the name in
Column B for the missing numbers.

Thanks