Debra Dalgleish has some notes:
http://www.contextures.com/xlFunctions03.html (for =index(match()))

Dave F wrote:

Yeah I was thinking it should be something with INDEX and MATCH. I have to
figure those two functions out. I like how you trap errors in the second
formula.

Thanks.

Dave
--
Brevity is the soul of wit.

"Dave Peterson" wrote:

You could also use a formula:

=INDEX($BA$1:$BL$1,MATCH(TRUE,$BA2:$BL20,0))

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

or just in case:

=IF(COUNTIF($BA2:$BL2,""&0)=0,"No positive numbers",
INDEX($BA$1:$BL$1,MATCH(TRUE,$BA2:$BL20,0)))

(still an array formula)

Dave F wrote:

I need a formula for the following:

Given range BA2:BL2, I need to find the first value in this range 0,
reading left to right, and then return the text in the corresponding cell in
the range BA1:BL1.

Example, if the first value 0 in the range BA2:BL2 is in BD2, I need the
text in BD1 returned.

Clear?

I hope so.

Thanks.

Dave
--
Brevity is the soul of wit.

--

Dave Peterson


--

Dave Peterson