How to find reference of cell from minimum value (Not a range)

**cmsheldon24** · 07-13-2012, 04:20 PM

I am trying to find a reference of a minimum value of a cell. So I have 4 locations and whichever value is the minimum, I want the name of the location to display. I have a lot of data in my LP so my cells that I'm finding a minimum from are not in a range. They are individually selected.

So far I have come up with this but it doesn't show the value of the minimum cell selected. Instead it shows the value of the first minimum in the selected range.

=INDEX(K11:K33,MATCH(MIN(N12,N18,N24,N30),N11:N33,0))

I also tried this but it doesn't work...

=INDEX(N12 N18 N24 N30,MATCH(MIN(N12,N18,N24,N30),N12 N18 N24 N30,0))

I'm not sure what to do now, so please help!

**JBeaucaire** · 07-13-2012, 04:53 PM

Like so:

=LOOKUP(2, 1/(($N$12:$N$30=MIN(N12,N18,N24,N30)) * (MOD(ROW($N$12:$N$30),6)=0)), $K$12:$K$30)

This only works because these cells are spaced evenly apart.