To find the same price in another sheet

  • Thread starter Thread starter pol
  • Start date Start date
P

pol

I have a column with name 'Item' which contain the code of the product.
Another sheet ( same file) contain code and profit.

Sheet1
item
A1
200
300
400
500
600

Sheet2
Item preofit
A1 B1
200 60
500 10
600 20
400 10

I have to find profit for the same item from sheet2 and to write in sheet1
column b1.

Please help
 
Use the Excels Help to learn about the function: VLOOKUP
Micky
 
Back
Top