Hello p45cal,

Sorry about the delay in getting back to you, but I thought I would re-run both options on a larger data set to see both options and compare the results.

The worksheet called Merged Sheets has your array formula in columns D to G.
The worksheet called BARRIER_RCS has the formula from the Ozgrid site.

In both worksheets I added data in columns J to P, that was copied from the CURR_LANE_WIDTHS worksheet to check the formula results against the expected results.
To ensure I had pasted the correct data I added a formula in column I, where 'In range' shows that the actual RRD is between the Start RRD and End RRD distances.

Unless I have made a mistake with both formulas you can see they do not match up.

It is looking like I will have to ask for one worksheet with all the values rather than do a complicated lookup.

Thanks for your help anyway.

Regards,
Dave T

Attached Files

Merged worksheets - Posted 29-11-2018.xlsx (127.3 KB, 11 views)