I want to use a VLOOKUP function to find data in a table that includes
ranges. Example:

# of tables Cost per table
1 €“ 19 $50.00
20 €“ 39 $45.00

If I then type 26 in a cell, $45.00 would appear. I can then have a simple
multiplication formula in the next cell to calculate total cost.

--
ray