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