Match worksheet

[Bob F]

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

 

[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

 

[Anubis]

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





:
-

You got good advice to use the VLookup formula. This is a pretty
simple case. I would suggest writing the formulas within the worksheet
that contains the current month data. It would seem that you are trying
to calculate any variance between the months for columns C, D, E, and F,
yes? If so then you will need one vlookup for each of those data.
Perhaps in column G you can write the first vlookup which would be
=vloookup(a1,"month 1 range a1:f100?,3,false). That will return the
value from column C for the item listed in row 1 on the month 2
workhsheet, which you can compare to what's in cell a3. the formula
for column H would be the same except for that the column reference
would be 4, and so on. If you get an error then that means this
particular item is not found in the month 1 worksheet.