Print Worker if between

Hi guys!

I was wondering if someone can help me generate a fucntion that would result to the following. The image attached would clarify more

Basically, I would want to print the Worker name if the number being is tested is in his range of work. Like for the first example. The number being tested is 1502. As we can see in column A:B, the worker assigned for that number is John. So "John" prints beside 1502. And so on and so forth.

Thanks everyone for the help in advance