Hi I do hope someone can help
I have a worksheet broken up into multiple road sections, each with its own ADT

Traffic
Road Road Name Start End ADT
563 ACOURT STREET 0 295 55
179 AHIPAIPA ROAD 0 2547 522
179 AHIPAIPA ROAD 2547 4027 344
179 AHIPAIPA ROAD 4027 4845 550


In another sheet I have a list of just over 2000 work sites, and I would like to populate this with the ADT for the site, taken from the road sections list
WORKSITES
Road Road Name Start Work ADT
179 AHIPAIPA ROAD 700 2 ?
179 AHIPAIPA ROAD 1858 R ?
179 AHIPAIPA ROAD 2192 R ?

For the example above the worksite that starts at 700 Ahipaipa Road would have an ADT of 522, as it is in the first section of Ahipaipa Road
I have tried various combinations of vlookup, match and index but could not seem to get anything to work