Hard to explain but ill try my best, thanks in advance
In a sheet I have roads, carriageways (part roads, referred to as cwayX) with various start and ends - e.g road1 cway1 1m-100m, road1 cway2 100m-200m, road2 cway1 1m-100m, road 2 cway2 100m-200m, road3 cway1 1m-100m, road3 cway2 100m-200m etc.
In another sheet I have roads with locations - e.g road1 38m, road3 104m etc.
How do I get the carriageway ID into the 2nd sheet?
edit: I should add, attached example sheet. The real one has thousands of rows
Cheers
Brad
Bookmarks