How do I select the first occurance of a certain number in a column and then,
as in the "Lookup" function, return a same numbered cell (different column).
I have "0's" and "1's" in my column (intermixed) and I am looking for the
first occurance of a "1". I then want to look up another value in the same
row (different column). "Lookup" function doesn't work if you have multiple
values not sorted. I'm using Excel 2003.