Find In A Range Of Serial Numbers

Sheet4 in my book looks like this:
.............A.......................B................................C..................

I......Invoice No…..…Starting Serial No……...……Ending Serial No
2…………ND12………..6011000000013652……. ..6011000000103652
3…………ND13………..6011000000116526……....6011000000246977
4…………RF4……….….6006000001255724……..…6006000011249564
5.........RF4...........6005000000023652.........6005000000095624

note that the last 4 numbers of the series are randomly generated for security reasons and are not part of the range of the the serial No’s

So Invoice ND = 10 consecutive numbers, Invoice ND13 = 14 and Invoice RF4 = 1000 and RF4(again) = 8

The list on this sheet is a mile long

What I need is a “search box” with two windows in it

In one box I will type a serial number and in the second box I will get the Invoice number

The challenge is that the serial number could be between Starting and Ending serial No’s thus if I were to type serial number
6006000001086598 in the first box the answer in the second box will be : RF4