Input an ID number, find it among 65 ranges, obtain birth year

[leosampieri]

Hello everyone,
thanks in advance for your time.
I've got this problem:
1. I have a list of almost 24K ID numbers.
2. I have a table with ranges, saying: "from ID #1.000.000 to ID #2.000.000 was born in 1920"; and so with another 65 ranges, saying from this ID to that ID was born in this year. Look: https://snag.gy/lGVoQ1.jpg
3. So, I must check every ID I have with these conditions. Of course, I need to obtain the year that ID was born.

How can I get this done?
Thanks !

 

[Rick Rothstein]

This worked, thanks !!

Just out of curiosity, how "regular" are the intervals for your ID ranges? For example, you said 1000000 to 2000000 was for 1920... are all your ID ranges 1000000 numbers big (that is, is 2000001 to 3000000 for 1921, and 3000001 to 4000000 for 1922, etc.)?