Second smallest

=INDEX($B$1:$E$1,1,MATCH(SMALL(IF($B2:$E20,$B2:$E 2),2),$B2:$E2,0))

Third

=INDEX($B$1:$E$1,1,MATCH(SMALL(IF($B2:$E20,$B2:$E 2),3),$B2:$E2,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mark McDonough" wrote in message
...
Following up on a previous query..........I am able to look along a row of
values and return the name of the cheapest supplier thanks muchly toJohn
Topely and Bob Philips.

To obtain the name of the supplier I tried
=INDEX($B$1:$E$1,1,MATCH(MIN(IF($B2:$E20,$B2:$E2) ),$B2:$E2,0))

as suggested and it works well.

Extending on that idea, how would I go about returning the name of the
supplier that had the next cheapest rate and the third cheapest given that
I
have 24 suppliers. For the purpose of illustration, I have only shown 3 in
my example.

Site Supplier A Supplier B Supplier C
Bilo1 175000 150000 125000
Bilo2 125000 50000 60000
Bilo3 50000 60000 70000

Any help appreciated


Cheers

Mark



----== Posted via Newsfeeds.Com - Unlimited-Unrestricted-Secure Usenet
News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+
Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption
=----