Thread: Can I use the offset function in combination with the min function?

Hi there! I have a list of stores and a list of prices. I want Excel to tell me which store has the lowest price.

Here's how my spreadsheet looks:
The first row has a list of stores. The second row has the price of an item at those stores. Like this:



Cell A1: Albertson's B1: Safeway C1: Target
Cell A2: $11 B2: $14 C2: $13

What I want is a formula to tell me that Albertson's has the lowest price on the item.
I know how to use the min function, but I don't want the formula to tell me the lowest price, I want it to tell me the store that corresponds to the lowest price (in the adjacent cell)

THANK YOU MARTIN!!
I had been trying to find a way to do this all morning.