to fetch the rebate from another worksheet using itemcode
 

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

to fetch the rebate from another worksheet using itemcode
 

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


"pol" wrote in message
...
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