Find a number from multiple range of numbers

Dear All,
I have two tables as mentioned below

Master Date Table No.1:-

Serial No. Quantity of Cards Start No. End No. Invoice No.
1 500 193201 193700 1A
2 1000 199701 200700 1B
3 1000 214301 215300 1C
4 1000 223101 224100 1D
5 1000 235101 236100 1E
6 1000 239601 240600 1F
7 1000 242601 243600 1G
8 990 243611 244600 1H
9 1000 262501 263500 1J
10 1000 275201 276200 1P

Search Result Table No.2

Card No Invoice No
214449 1C

I am looking for formula which would look up the card number in the entire range in table no.1 and return the invoice no.

Awaiting for awesome solutions.

Best Regards,

Shib