Solved: LOOKUP function not Functioning!

[Chisholm]

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]

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]

Thanks!
I read that stipulation of the formula, but couldn't figure out why the problem didn't seem to follow a pattern.