Trying --

Howze about:

A B
1 5 $200
2 10 $400
3 15 $600
4 20 $800
5 25 $1000


10 X =VLOOKUP(A10,$A$1:$B$5,2)

hth

"Trying To Excel" wrote:

A B
1-5 $ 200.00
6-10 $400.00
11-15 $ 600.00
16-20 $ 750.00
21-30 $ 1000.00

Question - If the value in a cell in Column A falls within a specified range
then the corresponding $ amount is in Column B.