To find the same price in another sheet

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top