Originally Posted by Bob F

Thank you Martin, I have looked at the 'vlookup' help and I can't see an
example to match several columns between 2 sheets. The key for the item is
column A to C and the match is for column D to F.
I am including a sample of my worksheet and wonder if you could give me an
example of the vlookup formula to compare columns D to F for all rows.
Month 1
A B C
D E F
4440 Chemineaud ***** brandy 750 42 3 29
4945 St-Leger scotch blended 1140 41 0 34
387027 Château des Tuileries Bordeaux 750 26 1 13
10454 Melchers Maxi Dry dry gin 750 12 0 12

Month 2

4440 Chemineaud ***** brandy 750 42 3 0
new 1 750 1 2 3
4945 St-Leger scotch blended 1140 43 0 0
387027 Château des Tuileries Bordeaux 750 26 1 0
567891 Domaine La Hitaire 750 1 0 0

Thank you in advance





"smartin" wrote:

Bob F wrote:
I have 2 worksheets, the first one shows results from last month while the
second shows resutls for the current month. What I need to get the ability to
identify any changes between the 2 months i.e. add, change, del.

Nothe both worksheets have the same number of column but not the same number
of rows. Is there a way to achieve this match within excel, thanks

Try VLOOKUP. Without knowing the structure of your worksheets a specific
solution cannot be given, but in general...

Adds are detected by looking up the keys in the new month against the
keys in the old month. !N/A means you have a new entry.

Changes are detected by looking up the values in the new month against
the values in the old month and testing for equality. Note since !N/A
means a new entry, you can combine the add formula with the change formula.

Deletes are the converse of adds: Look up the keys in the old month
against the keys in the new. !N/A means this record was deleted.

Play with VLOOKUP for a while and see if you can get this working.