my apologies, it was one row out.
Code:
=INDEX(CURR_LANE_WIDTHS!D$2:D$1015,MIN(IF(((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*(CURR_LANE_WIDTHS!$B$2:$B$1015<=$C2)*(CURR_LANE_WIDTHS!$C$2:$C$1015>=$C2))>0,ROW(CURR_LANE_WIDTHS!$A$2:$A$1015)))-1)
(Added a
-1 towards the end of the formula)
Where there are errors, you can IFERROR those out.