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.

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

Assume that both workbooks: Itemdetails.xls and Discount.xls
are open at the same time

Assume that your data is in Sheet1 in both books
(you must always specify the sheetnames involved)

Then in Itemdetails.xls,
in Sheet1,
place in D2: =VLOOKUP(A2,[Discount]Sheet1!A:B,2,0)
Copy D2 down to extract as required

For a neater look, you could use an ISNA error trap
to return blanks: "" for unmatched cases:
In D2: =IF(ISNA(VLOOKUP(..)),"",VLOOKUP(..))

--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"pol" wrote:
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.

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