Vlookup in a range (or something)
I have a number of test results from road works that I need to extract the result from, but I can't puzzle out how to do it.
The test result (a compaction percentage) covers a stretch of road from a point (chainage) to a point e.g. from chainage 0+500 to chainage 0+700 (meaning from 500m to 700m). The test result covers that entire stretch.
I need to transfer the test result into a summary sheet which shows the entire road split up in 20 meter sections.
In the example above the test result would cover the ten 20 meter sections between 0+500 and 0+700.
How do I do that?
In the attached I have entered the data manually and highlighted the data used with red.
/Møller
|