(TABLE) Help writing formula to display column header of a result

[scarch05]

Hi,

I am trying to make a worksheet with a table that lists a range of items, with a row of shops as column headers. In the final column of the table I have a MIN formula locating the cheapest value for each item across the shops.

What I can't figure out is: what formula would I need to write in order for Excel to display the column header (i.e. shop name) of the resulting cheapest value?

I am very new to Excel, and realise this is probably a very basic question but I am really stuck! I have tried to write a combination of MATCH, VLOOKUP etc. but am getting very confused.

Thank you!

[inayat]

Please see attached.. Hope it helps.

[Marcol]

@ inayat
I suspect that the formula will need to be dragged down so an absolute reference and a handler for empty rows will be required in your formula.

Please Login or Register  to view this content.

or for pre-2007 versions of Excel

Please Login or Register  to view this content.