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?