'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

'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

'IF','LOOKUP' or 'HLOOKUP'?
 

Sorry!


F2=INDEX($A$1:$D$1,,MATCH($E2,$A2:$D2,0))

'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))

'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))