PDA

View Full Version : Solved: LOOKUP function not Functioning!



Chisholm
07-09-2008, 10:14 AM
I'm trying to use the LOOKUP function, and it's not working for some reason.

I have a series of columns, in which there is only one "1" in each row.
I'm trying to lookup the "1" and have LOOKUP return the corresponding column header.
For some reason, LOOKUP is returning the header to the wrong column.

I've been trying to figure this out, but have had no luck.
Anyone have any ideas?
I've included a sample sheet.

TheComp
07-09-2008, 10:59 AM
The reason it's not working is because Lookup requires that the Lookup Range be in ascending order. Try a combination of INDEX and MATCH.

Use this formula in H2. Then copy down.

=INDEX($A$1:$F$1,1,MATCH(1,A2:F2,0))

Regards,
Paul

Chisholm
07-09-2008, 11:35 AM
Thanks!
I read that stipulation of the formula, but couldn't figure out why the problem didn't seem to follow a pattern.