Conditional search

Hello people,

Ok this is my problem and my partial solution.

i have a table with the same structure but bigger (about 3000 records) and all i want is:

1. If i put a value in F2 (brands in this example) and their plate number in G2
the function should check A2:A13(brands) and B2:C13 (plates ranges) and get the correct number of lot.
2. Should be able to get multiple values instead of just one at a time like in my example.

Note: I added _ to lots to make "MATCH" function work and 100000 to provide a infinity equivalent.
I think VLOOKUP function could be implemented.

Thanks.

lookuphelp.PNG