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

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