Hi, I am trying to figure out how to write a formula to return a value from a DIFFERENT ROW but SAME COLUMN, when a row criteria is met. I can't figure out how to make it work and I am hoping someone can help!
Here is what I am trying to do: in [another sheet], if the date in [row] is [>=Today(+15)] return value in [field] within same row and column.
i.e. if [allocation sheet] has a date in [row 1] that is [within the next 15 days] return the value in [row 2] within [the identified column]
If allocation sheet has a date in row 1 between 15 days and 30 days, return the value in that column in row 2
and so on…
In screenshot: On Sheet "Allocation" if the date in row 1 is [within the next 15 days], return the value in that column (i.e. W09) in row 2 (i.e. 83%) and row 3 (i.e. 31)
Is there a way to do this? Can anyone help me figure this out?
THANK YOU in advance!