find first value in column, and return the corresponding row in the A column

[bjcowen9000]

Hello,

In column c I want to look at values in B. The first time anything appears other than 0, I want to return the corresponding value in column A. How can this be done?

[Tony Valko]

Maybe something like this...

Array entered**:

=INDEX(A1:A10,MATCH(TRUE,B1:B10<>0,0))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

[Pete_UK]

You can use this array* formula in C2:

=INDEX(A:A,MIN(IF(B2:B10>0,ROW(B2:B10))))

assuming the data is in rows 2 to 10 - adjust as required for the two terms involving column B.

* Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE), rather than the usual < Enter >

Hope this helps.

Pete