Try
Array-Entering (
Ctrl+Shift+Enter, not just
Enter) this formula in cell D2 of sheet
Merged Sheets. Copy down and across.
Code:
=INDEX(CURR_LANE_WIDTHS!D$2:D$70,MIN(IF(((CURR_LANE_WIDTHS!$A$2:$A$70=$B2)*(CURR_LANE_WIDTHS!$B$2:$B$70<=$C2)*(CURR_LANE_WIDTHS!$C$2:$C$70>=$C2))>0,ROW(CURR_LANE_WIDTHS!$A$2:$A$70))))
It returns zero for where there are blank cells in
CURR_LANE_WIDTHS, but you could wrap the whole formula in an
IF statement to return a blank instead, if you're confident there are no lane widths of zero.
11-27-2018, 04:18 PM
Similar Threads
How can I retreive multiple records using a lookup?
Windows 10 
Office 2016
Threaded Mode