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
|