Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match roll in sheet 1 to 2
I need to match (or vlookup) information in roll 1 in sheet 1 is the same as
one of many rolls in Sheet 2, if the rolls' information matches sheet 1 to sheet 2, then subtract the last cell of both sheets. eg, in Sheet 1, A B C D E (result) 1 Car Red Auto 10000 11000 (21000-10000) 2 AWD Blue Semi 45000 14000 (45000-31000) 3 Truck Yellow Auto 45000 Error (B3 diff to Sheet2 B1) in Sheet 2, A B C D 1 Truck Green Auto 50000 2 Ute Yellow Man 35000 3 Car Red Auto 21000 4 AWD Blue Semi 31000 Many thanks in advance Keith |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Match roll in sheet 1 to 2
I have tried this formula
=SUMPRODUCT(--(MATCH(sheet1!$A1,sheet2!!A:A,0)),--(MATCH(Sheet1!$B1,Sheet2!B:B,0)),--(MATCH(Sheet1!$E1,sheet2!E:E,0))) But I am still trying find what is the formula to use to subtract the last cell of the roll if all criterias have been met. Any help will be most grateful. Again, thanks in advance "Kikkoman" wrote: I need to match (or vlookup) information in roll 1 in sheet 1 is the same as one of many rolls in Sheet 2, if the rolls' information matches sheet 1 to sheet 2, then subtract the last cell of both sheets. eg, in Sheet 1, A B C D E (result) 1 Car Red Auto 10000 11000 (21000-10000) 2 AWD Blue Semi 45000 14000 (45000-31000) 3 Truck Yellow Auto 45000 Error (B3 diff to Sheet2 B1) in Sheet 2, A B C D 1 Truck Green Auto 50000 2 Ute Yellow Man 35000 3 Car Red Auto 21000 4 AWD Blue Semi 31000 Many thanks in advance Keith |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup function and compare | Excel Discussion (Misc queries) | |||
Help me, compare 2 sheet and extract the match data into the new sheet. | Excel Discussion (Misc queries) | |||
Copying a column to a new sheet so that cells match. | Excel Worksheet Functions | |||
Vlookup, Index & Match | Excel Worksheet Functions | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |