Excel 2003

[Vince]

I receive alot of supplier quotes and have set up a spreadsheet using the
MINA function to automatically put the cheapest price in a column from across
the row of supplier prices. What I would like to do now is automatically
select the supplier name from the top of the column that it selected the
cheapest supplier price from and display it the column next to it. I can't
seem to fathom that one out. Help.

Thanks

Vince

 

[T. Valko]

Try this...

...........A..........B..........C..........D
1.....Sup1....Sup2.....Sup3.....Sup4
2.....100......420.......95.........127

=INDEX(A11,MATCH(MIN(A22),A22,0))

Result = Sup3

 

[Vince]

Thanks for that, worked beautifully

Vince