You don't need a table for your example. If the age is entered in cell A! then

=(A1=10)*(A1<=20)*3+(A1=21)*(A1<=30)*4+(A1=31)* 5

will yield the correct dollar amount
--
Gary's Student


"jw446" wrote:

Trying to create a table that will pull a price based on a value within a
range. Trick is I'm trying not to enter the entire range into the pricelist.
Example logic is "If you're aged 10-20, then you can enter for $3. If
you're aged 21-30, then you enter for $4. If you're 31 or older, you enter
for $5."