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.
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.