Nesting more than 7 conditions?

G

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?
 
J

JMB

Look at Index/Match

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

Adjust the ranges as necessary:
 
B

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)
 
P

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
 
G

Gina

Thank you so much, it works!

Peo Sjoblom said:
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top