Vlookup in between two numbers

[kumatae]

I don't think Vlookup is going to be my solution but it's close to what I want it to do. In Sheet 1, I have a list of ID numbers with blank columns of CITY.
In Sheet 2, I have a list of ranges of ID Numbers that is associated with a city.
I need a formula or VBA code that will go through each of the ID numbers in Sheet 1 against the ranges in Sheet 2 and return the city associated in Sheet 2 to Sheet 1.

I'm very familiar with Vlookup and have used it extensively but don't feel like it is going to work here. I'm thinking perhaps VBA but hoping for a simple formula. Thank you!

Sheet 1

ID_NUMBER	CITY
5
15
29
31
44
58

Sheet 2

CITY	BEGIN_ID_NUMBER	END_ID_NUMBER
LOS	1	10
SEA	11	20
LAS	21	30
POR	31	40
DAL	41	50
SFO	51	60

 

[Fluff]

How about

=INDEX(Sheet2!A2:A100,MATCH(A2,Sheet2!B2:B100,1))

 

[kumatae]

How about

=INDEX(Sheet2!A2:A100,MATCH(A2,Sheet2!B2:B100,1))

Thank you so much! My original Sheet 2 has ID numbers that vary and were all out of sort so it gave me results that weren't accurate but when I sorted, it worked perfectly! Thank you once again!

 

[Fluff]

You're welcome & thanks for the feedback.