| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to write a formula to findout itemcode,discount from another works | Excel Discussion (Misc queries) | |||
| fetch values from w/sheet | Excel Discussion (Misc queries) | |||
| Rebate incentive - Multiple tier payback - Confusing if Statement | Excel Discussion (Misc queries) | |||
| Calculate a quantity rebate | Excel Worksheet Functions | |||
| Where do I obtain a rebate log templete? | Excel Discussion (Misc queries) | |||
Linear Mode
