Hello All,
I was showing a work colleague the formula from the Ozgrid post (in my second attachment) and he found out I had made a mistake.
The formula in columns D to G on the BARRIER_RCS worksheet should have been:
Code:
=IF(SUMPRODUCT((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*($C2>=CURR_LANE_WIDTHS!$B$2:$B$1015)*($C2<=CURR_LANE_WIDTHS!$C$2:$C$1015),ROW(CURR_LANE_WIDTHS!$D$2:$D$1015))=0,"",INDIRECT("CURR_LANE_WIDTHS!D"&SUMPRODUCT((CURR_LANE_WIDTHS!$A$2:$A$1015=$B2)*($C2>=CURR_LANE_WIDTHS!$B$2:$B$1015)*($C2<=CURR_LANE_WIDTHS!$C$2:$C$1015),ROW(CURR_LANE_WIDTHS!$D$2:$D$1015))))
The column ID (in blue) will need to be changed each time as you drag the formula from column D to G.
Just thought I would post this followup as it is another alternative that is not an array formula.
Regards,
Dave T