software

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:quot;Ginaquot; wrote:

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

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)

quot;Ginaquot; gt; wrote in message
news
gt; What is an easier way when you have to nest more than seven conditions,
gt; example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm
gt; typing in the formula to input the information from the cell directly
above
gt; from the cell that meets the condition. Does that make sense?
gt;
gt;
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)),quot;no
Matchquot;)

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Ginaquot; gt; wrote in message
news
gt; What is an easier way when you have to nest more than seven conditions,
gt; example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm
gt; typing in the formula to input the information from the cell directly
gt; above
gt; from the cell that meets the condition. Does that make sense?
gt;
gt;Thank you so much, it works!

quot;Peo Sjoblomquot; wrote:

gt; Maybe this will work
gt;
gt; =INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0))
gt;
gt; to make it dodge errors
gt;
gt; =IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$ V$7,MATCH($W$8,$D$8:$V$8,0)),quot;no
gt; Matchquot;)
gt;
gt; --
gt; Regards,
gt;
gt; Peo Sjoblom
gt;
gt; Portland, Oregon
gt;
gt;
gt;
gt;
gt; quot;Ginaquot; gt; wrote in message
gt; news
gt; gt; What is an easier way when you have to nest more than seven conditions,
gt; gt; example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell I'm
gt; gt; typing in the formula to input the information from the cell directly
gt; gt; above
gt; gt; from the cell that meets the condition. Does that make sense?
gt; gt;
gt; gt;
gt;
gt;

Thanks for the feedback

--
Regards,

Peo Sjoblom

Portland, Oregon

quot;Ginaquot; gt; wrote in message
...
gt; Thank you so much, it works!
gt;
gt; quot;Peo Sjoblomquot; wrote:
gt;
gt;gt; Maybe this will work
gt;gt;
gt;gt; =INDEX($D$7:$V$7,MATCH($W$8,$D$8:$V$8,0))
gt;gt;
gt;gt; to make it dodge errors
gt;gt;
gt;gt; =IF(ISNUMBER(MATCH($W$8,$D$8:$V$8,0)),INDEX($D$7:$ V$7,MATCH($W$8,$D$8:$V$8,0)),quot;no
gt;gt; Matchquot;)
gt;gt;
gt;gt; --
gt;gt; Regards,
gt;gt;
gt;gt; Peo Sjoblom
gt;gt;
gt;gt; Portland, Oregon
gt;gt;
gt;gt;
gt;gt;
gt;gt;
gt;gt; quot;Ginaquot; gt; wrote in message
gt;gt; news
gt;gt; gt; What is an easier way when you have to nest more than seven conditions,
gt;gt; gt; example: =IF(W8=D8,D7, IF(W8=E8,E7,IF(W8=F8,F7...... I want the cell
gt;gt; gt; I'm
gt;gt; gt; typing in the formula to input the information from the cell directly
gt;gt; gt; above
gt;gt; gt; from the cell that meets the condition. Does that make sense?
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;