Table Lookup - Multiple Criteria

Hi !

I'm hoping someone can point me in the right direction!

I have a table of values (Please see attachment) which I need to query, then return a result based matching a range, as well as meeting one other criteria.

Units 1 2 3 4 5
20-49 3.67 4.43 5.18 5.99 6.80
50-99 2.16 2.48 2.92 3.35 4.05

User needs to enter a unit qty: 55
User needs to enter a number qty (EG:1,2,3,4 or 5): 3

Formula needs to return the price/value 2.92

The formula will need to determine that the unit qty entered sits within the range (50-99), then will need to display the price/value based the number qty entered (3).

Thus, displaying: 2.92 !

Simple for you I'm sure.... bugging the sh|t out of me! Any assistance would be greatly appreciated.

Thanks!JDW-TableLookup.xlsx