I have a report where the data is displayed as

In a different report I have a list of IDs that I match with the list in the original report.
Some IDs that I’m trying to get a name for are in-between the values displayed such as 84286.

Ive tried to use the below formula to get a result but its not returning the correct values.
=INDEX('[DID Codes.xlsx]DID Codes'!$E:$E, MATCH(1, (Y2 >= '[DID Codes.xlsx]DID Codes'!$C:$C) * (Y2 <= '[DID Codes.xlsx]DID Codes'!$D:$D), 0))

Any assistance will be greatly apricated