Lookup with Min

[ounvme2]

Hi.
I am trying to find the lowest number in row 3 and report its associated column heading in row 2.

My formula is =LOOKUP(MIN(LE3:PJ3),LE3:PJ3,le2j2)

However, it returns N/A...

Trying this with just a few numbers it seems to work if the row is in ascending order....


How can I fix this.

Thanks.

 

[MrKowz]

Try, instead, use INDEX/MATCH:

=INDEX(LE2:PJ2,MATCH(MIN(LE3:PJ3),LE3:PJ3,0))

 

[ounvme2]

Thanks Mr. Knowz, that worked!

 

[Aladin Akyurek]

See Post #6 in:

http://www.mrexcel.com/forum/showthread.php?t=496358