using vlookup help

[-keevill-]

Every few weeks I get an excel sheet which consists of several columns of
items. The first column is the name of the complete item and across the
sheet each subsequent row contains the parts contained in the finished (
complete ) item.
When I get a new sheet there are additions in the sheet and sometimes
removed rows .
How can I use vlookup to list the new / removed items ?
Right now I have to manually view both sheets and go through them to see the
new/deleted items.

 

[Bob Phillips]

Use conditional formatting to highlight the new and the deleted items.

You can do it with a formula such as

=COUNTIF(Sheet1!A:A,A1)

and pick a format colour.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)