Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
HLOOKUP Question
I have a table
Price 25 35 70 55 20 15 80 item Bell Cable Vac Security Ex Bell Ex Cable Ex Vac Lot s* s* s* s* e* e* e* 101 2 3 1 1 1 1 1 102 2 3 1 1 2 3 1 103 2 3 1 1 1 2 2 104 2 3 1 1 3 5 1 s* - Standard, e* - Extra Then I have another table Lot Description Units Type Unit Price Total Price drop Drop down menu IF,OR ? IF,OR formula down formula menu I need a way to to fill the Type (?) field with respect to the table, which is standard or Extra depending on the item. And the Total price is calculated based on if it is the standard item, it is the same price as in Table 1, is it is Extra, it is the price on the Table 1 multiply that by the number of units. Anyone know the solution, please email me at Thnx Prakash..... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup-row_index_num question | Excel Worksheet Functions | |||
HLOOKUP question | Excel Worksheet Functions | |||
VLOOKUP / HLOOKUP Question | Excel Discussion (Misc queries) | |||
VLOOKUP/HLOOKUP Question | Excel Discussion (Misc queries) | |||
HLookup function question | Excel Programming |