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 |
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 |