Nesting more than 7 conditions?

[Gina]

What is an easier way when you have to nest more than seven conditions,
example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm
typing in the formula to input the information from the cell directly above
from the cell that meets the condition. Does that make sense?

 

[JMB]

Look at Index/Match

=INDEX(D7:F7,MATCH(W8,D8:F8,0))

Adjust the ranges as necessary:

 

[Bob Phillips]

If the formula is in say D8, why not just use

=D7

If you copy it elsewhere, it will adjust.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Peo Sjoblom]

Maybe this will work

=INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0))

to make it dodge errors

=IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0)),"no
Match")

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Gina]

Thank you so much, it works!

Maybe this will work

=INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0))

to make it dodge errors

=IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0)),"no
Match")

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Peo Sjoblom]

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon