Im looking for a formula alternative to lookupV that can bring me a column after meeting 2 criterias. (With out concatenate)

Question

Im looking for a formula alternative to lookupV that can bring me a column after meeting 2 criterias, with out using concatenate.

I have a "Table A" with 4 columns:

1. City
2. Begining Range Number
3. Ending Range Number
4. Price

I have a "Table B" with two columns.

1. City
2. Number

I need to bring the Price from "Table A" to Table B". To do that I must make sure that:

1. Number from TABLE B is between "Begining Range Number" and "Ending Range Number" from TABLE A.
2. That the city from TABLE A matches the city from TABLE B.