Please help to get cross reference with another sheet

[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.

With many thanks
Pol

 

[new1]

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.

With many thanks
Pol

Hello

If i understand well your question, this can be done with the help of
the vlookup function : this function is used to retrieve the profit of
a given item in sheet2, sheet which is used as a reference table.
In the B2 cell of Sheet1, try this formula

= VLOOKUP(A2;SHEET2!A:B;2;FALSE)

where
A2 is the cell containing the item code you're looking for;
SHEET2!A:B ( means the columns A and B of sheet 2) is used as the
profit per item reference table;
2 is the column rank from the reference table (defined above) from
which we want to retrieve the data
FALSE specifies that we're looking for the perfect match between
Sheet1!A1 and the values of Sheet2 colum A.

If it's ok, you can copy the formula on the other rows of Sheet1.

HTH

new1@[no/spam]realce.net