Trying to figure out how to get an Excel sheet to recognize what links belong to a segment

PM No Build 2031 Redacted.xlsx

PM_No Build_2031_Link Segment Results.att.xlsx

Good Time Zone,

I have a question - the “Redacted” file has segment numbers that consist of individual links. How do I use the LINKEVALSEGMENT\LINK column in the other file to assign a segment to each link (just FYI I’ve already combined the individual lanes on each link into a single row in my workflow I’m just wondering if there’s a function I can use to give eacn link a segment number.