Excel Index Match with date and multiple criteria returning #N/A

Originally Posted by bebo021999

With date are sorted as per sample, try:

=LOOKUP(2,1/($A$2:$A$16="test")/($F$2:$F$16<=Q2),$N$2:$N$16)

You're awesome! This worked, however it will only work as long as the dates are in order. I can't count on that 100% though.

I would still rather the index/match work as it's more reliable long term though