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!