vlookup?

[Chris]

I need a formula that looks across b2:z2 for the number 1 and then
returns the text value of row 1 in the column that the number 1 is
found in.

Any suggestions on the formula?

Thanks.

 

[Elkar]

Try this:

=INDEX(B1:Z1,1,MATCH(1,B2:Z2,0))

HTH
Elkar

 

[Chris]

Try this:

=INDEX(B1:Z1,1,MATCH(1,B2:Z2,0))

HTH
Elkar







- Show quoted text -

perfect, thanks!

 

[Shane Devenshire]

Hi,

And another alternative:

=OFFSET(A1,,MATCH(1,B2:Z2,))