Nesting more than 7 conditions?
 

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?

Nesting more than 7 conditions?
 

Look at Index/Match

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

Adjust the ranges as necessary:


"Gina" wrote:

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?

Nesting more than 7 conditions?
 

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)

"Gina" wrote in message
...
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?

Nesting more than 7 conditions?
 

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" wrote in message
...
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?

Nesting more than 7 conditions?
 

Thank you so much, it works!

"Peo Sjoblom" wrote:

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" wrote in message
...
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?

Nesting more than 7 conditions?
 

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon




"Gina" wrote in message
...
Thank you so much, it works!

"Peo Sjoblom" wrote:

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" wrote in message
...
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?