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?

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

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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?
>
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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?
> >
> >
>
>

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon




"Gina" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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?
>> >
>> >
>>
>>