Formula to return vendor name of lowest value

[hturner0110]

Hello,

I've drawn up a table to work out where to do the grocery shopping, with Column A containing the item, then columns B-I having the pricings. So cell B1 is Sainsbury, and then cell B2 is the price of apples at Sainsbury, while cell C1 is Tesco and cell C2 the price of apples in Tesco.

In column J I would to have the name of the store with the lowest price. I need a formula that determines which column has the lowest price, and then gives me the name stated in the top cell. How do I do this?

 

[Fluff]

Hi & welcome to MrExcel.
How about

=XLOOKUP(MIN(B2:J2),B2:J2,B1:J1)

 

[hturner0110]

Hi & welcome to MrExcel.
How about

=XLOOKUP(MIN(B2:J2),B2:J2,B1:J1)

Works a treat! Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.