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,le2
j2)
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.
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,le2
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.