List with prices and suppliers sorted by lowest price and which supplier has it

[SjoisW]

I have a list with items in the rows, suppliers email me their prices which I then paste in the columns.

I want to know which supplier gives me the lowest price for an item without having to look at all the prices in the row. First I sorted horizontally, but I cannot do this for the entire list
since it wil sort the prices, but not the supplier name, since that is different each time.

I then added a new colum and used the formula MIN, now at least I can see the lowest prices, but I would love to have a formula to also show me the name of the supplier beloning to that prices. (supplier names are all in row 1).

[63falcondude]

Try this in H2:

=INDEX(C$1:E$1,MATCH(G2,C2:E2,0))

[alansidman]

In column H, put this and copy down

=INDEX($C$1:$E$1,MATCH(G2,C2:E2,FALSE))

EDIT: 63Falcondude types faster