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.