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?