Display value from 1st row in a column based on MIN statement

**RHart3** · 11-12-2009, 06:26 PM

Hey all,

I'm hoping someone here can help me out. I need to write a MIN formula that displays the value from row 1 in the column instead of the actual minimum value in that range.

I.E...

Bob Sue Jerry
2 1 3

I need to select the MIN value, (1) but display "Sue" instead.

To make things a little more complex.. I'm currently using a CSE formula to select the MIN value based on true/false statements on another page.

=MIN(IF(Summary!$F$3:$P$3,$J5:$T5,FALSE))

Can I even accomplish what I'm trying to do? Any guidance is appreciated. Thanks.

**darkyam** · 11-12-2009, 06:32 PM

If the names are A1:C1 and the numbers in A2:C2, try =INDEX(A1:C1,1,MATCH(MIN(IF(Summary!$F$3:$P$3,$J5:$T5,FALSE)),A2:C2,0)) and confirm with CSE.

**Paul** · 11-12-2009, 06:33 PM

If A1="Bob", B1="Sue", C1="Jerry" and A2=2, B2=1, C2=3 (regardless of how those numbers got there - static or formula), then try:

=INDEX(A1:C1,0,MATCH(MIN(A2:C2),A2:C2,0))

**teylyn** · 11-12-2009, 06:33 PM

How about

=INDEX(A1:C1,1,MATCH(MIN(IF(Summary!$F$3:$P$3,$J5:$T5,FALSE)),A2:C2,0))
submit with Ctrl-Shift-Enter

**darkyam** · 11-12-2009, 06:34 PM

Yeah, good point, Paul. I guess I overlooked the obvious on the Min part.

**darkyam** · 11-12-2009, 06:35 PM

I don't think that works, Teylyn. If that Min is 1, it will return the first value, Bob, instead of Sue.
*Edit: nevermind, formula now completed.

**teylyn** · 11-12-2009, 06:43 PM

I'm not quite sure if the OP does not really want to lookup the value that the MIN Array formula returns, and then Index/Match on that value.

The way the MIN array formula is set up, it will return a minimum value from the $J5:$T5 range, and as I understood, this value should be matched to the name.

But maybe I've misread it.