Hello,
I have two sheets with 5 columns each; item number, description, quantity on-hand, price & total value.
I want to match the columns on sheet B (old report) with the columns on sheet A (new report) and whatever does not match leave on Sheet B; I need to see what items are no longer in inventory since the old report. Can you please help me?
 

---

Answer from Richard Rost:

You could perform a VLOOKUP to see if the item still exists in the second sheet.

You can use the VLOOKUP or HLOOKUP function.

VLOOKUP is a powerful function in Microsoft Excel that allows you to look up a value from another spreadsheet - or a smaller subtable (lookup table).

See this FREE tutorial for help with VLOOKUP:

http://599cd.com/tips/excel/vlookup/?key=BlFAlEx

---

Answer from Richard Rost:

You could perform a VLOOKUP to see if the item still exists in the second sheet.