Hello,
I thought I knew how to do this, but for some reason I can't get it to work.
For example:
This formula returns the value I need to look up in range $W$16:$DUR$16.
COUNTIF($W$15:$DUR$15,"<"&S$18)+V18
Once the value is found in that range I need the formula to return the value of the...