formulas

I want to enter a price chart for a product that has
specific prices for specific sizes. I want to enter a
size and have a formula find that specific size among a
group of sizes and determine what price it is and enter
that figure in a cell. How would I word the formula to
get it to do that? Help! Thanks.

Try something like

=VLOOKUP(A1,Sheet2!A2:B100,2,0)

where A1 is the cell you enter the size and on sheet2 A2:B100 is the table
with the sizes
in A2:A100 and the prices in B2:B100

Adapt to fit your real data

--

Regards,

Peo Sjoblom

"Andrea" wrote in message
...
I want to enter a price chart for a product that has
specific prices for specific sizes. I want to enter a
size and have a formula find that specific size among a
group of sizes and determine what price it is and enter
that figure in a cell. How would I word the formula to
get it to do that? Help! Thanks.