I have a shapefile of city streets polylines and an excel sheet with similar data. I need to select a street segment based on the two segments it intersects. Then I add the value from the "ID" field that corresponds with the excel sheet. Right now, I have to do this manually for thousands of segments by looking at the map and finding the intersecting streets, then copy/paste the ID into the attribute field. Is there a way to automate this process based on segment intersections or endpoints? The segments in the excel sheet and table are not in the same order.
ArcGIS Desktop 10.5.1, Basic