to fetch the rebate from another worksheet using itemcode

[pol]

I have two excel sheet
1. Itemdetails.xls
2. Discount.xls.
The itemdetails.xls contain the following column.
1. itemcode[A1]
2. Description [B1]
3. Rate [C1]
4. Rebate [D1]
The discount.xls contain the following column
1. itemcode[A1]
2. Rebate [b1]
Now the cursor standing at itemdetails.xls column D2. Here I need to have
a formula to find out the rebate from discount.xls for the corresponding
ipcode and to write in D2 in the worksheet itemdetails.xls

If value of itemdetails .itemcode[A1] EXIST IN discount.itemcode, then
itemdetails.REBATE=DISCOUNT.REBATE of the corresponding ipcode. Please help
me to write the formula in cell D2 of itemdetails

Please help

 

[DK]

Please don't start a new thread for the same issue.
Your question was answered in you other post. If still need more assistance,
reply in that thread.

DK