data validation

[caveman-with-fire]

Ok i've set up a excel sheet with the drop down options of 6 to 22.

what i need now to do is in another excel box to appear a value

ie: if 7 is selected in the "other" excel box the value appears -> $1,100

the value range is;


6 $1,000.00
7 $1,100.00
8 $1,200.00
9 $1,300.00
10 $1,400.00
11 $1,500.00
12 $1,500.00
13 $1,500.00
14 $1,500.00
15 $1,500.00
16 $1,500.00
17 $1,500.00
18 $1,500.00
19 $1,500.00
20 $1,500.00
21 $1,500.00
22 $1,500.00

Thx in advance

[grizzly6969]

Take a look at this work sheet --- see if it's what you are looking for

[caveman-with-fire]

legend thx

[grizzly6969]

glad I could help & thanks for feed back