Two Sheets; On Comparison :)

[RRico]

Two Sheets; One Comparison

Problem:
Have data in two sheets named "Old" & "New."

Looking to compare both Column A's within both sheets respectively to determine what's missing on the "New" sheet after comparing against the "Old" sheet.

Rationale:
Every day, orders come across on a report and I'd like to show which orders were worked and therefore missing from the New report by comparing against the old report.

Hmph...:
Tried VLOOKUP and MATCH, but they don’t seem to quite give the “missing / difference” in the sense that I need to which/how many orders were worked from one day to the next.


Thanks to Anyone who thinks they know how to best show this... it seems simple, but I just can't figure it out :/

 

[RRico]

Re: Two Sheets; One Comparison

If I am understanding you, then all you need to do is switch it around so that you are doing the VLOOKUP the other way, i.e.
=IFERROR(VLOOKUP('Old'!A2,'New'!A$2:A$500,1,0),"NOT FOUND!!!")
copy down for as many rows as entries you have on old your old sheet.

But of course Joe Thanks so much for having a clearer head that I on this one and brining your knowledge into action. I will review the "attachment" thread you supplied to aid in any future posts as well.

Thank you again,
RR