I need to look up information using multiple variables, one of those
variables using a range. I want the associate number returned based on where
they fall in the sequence and batch number. The following is an example:

SHEET ONE:
Sequence Start Sequence End Batch Associate
07953 07988 322 201
07989 08013 322 247
41222 41238 213 232
00238 00252 001 228
SHEET TWO:
Sequence # Batch Associate
07999 322 ??????

Based on this example the associate number that should be returned is 247.
Thank you all in advance for your help!!!!