View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kikkoman
 
Posts: n/a
Default 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