Very helpful thanks. Curly braces are half my battle, I think. Is there any
way to replace the hard-coded values in the array with cell references?

Many thanks.

"Ron Coderre" wrote:

Try this formula:

=VLOOKUP(A1,{0,0;10,3;21,4;31,5},2,1)

Note the curly braces, the commas, and the semicolons.
The braces define an array.
The commas separate values in a row.
The semicolons are like carriage returns and begin a new row.

Effectively, the values within the braces are the equivalent of a 2 column
range of values:
_0____0
10____3
21____4
31____5

Does that help?

--
Regards,
Ron


"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."