Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF','LOOKUP' or 'HLOOKUP'?
Need your help O gurus!
See chart below. vendor 1 vendor 2 vendor 3 vendor 4 Min. Cost Min. supplier part 1 $1 $2 $4 $5 $1 part 2 $7 $10 $8 $11 $7 part 3 $15 $11 $14 $12 $11 I am struggling with a formula that will generate the name of the Min. Cost supplier in the last column. For example, for part 1, the min. cost supplier is vendor 1; for part 3 it is vendor 2. What formula can I use to generate this automatically? Thanks Rajan |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF','LOOKUP' or 'HLOOKUP'?
Hi
On fly: E2=MIN($A2:$D2) E2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0)) -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Rajan Iyer" wrote in message ... Need your help O gurus! See chart below. vendor 1 vendor 2 vendor 3 vendor 4 Min. Cost Min. supplier part 1 $1 $2 $4 $5 $1 part 2 $7 $10 $8 $11 $7 part 3 $15 $11 $14 $12 $11 I am struggling with a formula that will generate the name of the Min. Cost supplier in the last column. For example, for part 1, the min. cost supplier is vendor 1; for part 3 it is vendor 2. What formula can I use to generate this automatically? Thanks Rajan |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF','LOOKUP' or 'HLOOKUP'?
Sorry!
F2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0)) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF','LOOKUP' or 'HLOOKUP'?
Thanks Arvi. Will Try this solution.
-- Rajan "Arvi Laanemets" wrote: Sorry! F2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0)) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
'IF','LOOKUP' or 'HLOOKUP'?
Arvi,
Good Job, the solution worked. -- Rajan "Arvi Laanemets" wrote: Sorry! F2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup combine vlookup with hlookup | Excel Worksheet Functions | |||
Help with Hlookup/Vlookup and Lookup. From multipul sheets | Excel Worksheet Functions | |||
HLOOKUP - Adjusting the lookup value... | Excel Discussion (Misc queries) | |||
Multiple lookup values in =HLOOKUP | Excel Discussion (Misc queries) | |||
Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) |