Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match worksheet
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match worksheet
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match worksheet
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. |
#4
|
|||
|
|||
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Match to find value on worksheet | Excel Worksheet Functions | |||
Match() worksheet function | Excel Worksheet Functions | |||
Look up and match Vendor name in one cell of worksheet from list ofmultiple Vendor names in column of other worksheet | Excel Worksheet Functions | |||
Match WORKSHEET | Excel Worksheet Functions | |||
Match 2 worksheet | Excel Worksheet Functions |