Multiple drop down list box

[Guest]

I want to create a drop down list with values
vx8500 with a value of $250.00
vx8600 with a value of $249.00
vx9900 with a value of $329.00
next would be to choose a plan catagory
$0.00-34.98 value of 180.00
$34.99-59.99 value of 280.00
next the price
so lets say 100.00

and at the end it will calculate the amount so if vx8500 was chose and plan
of 34.99-59.99

280.00(plan) - 250.00(cost) + 100.00(price paid for vx8500)

i also do not know how to put values for those items
so far i've got one drop down list

please help thank you

 

[Guest]

one way:

Create two tables (named Ranges) called "ProductTable" and "PlanTable", each
consisting of two columns as shown below.

The column headed "Product" is a named range as is the column headed "Plan"


--ProductTable--- --------PlanTable-----------------
Product Cost Plan Cost
VX8500 $250.00 $0.00-$34.99 $180.00
VX8600 $249.00 $34.99-$59.99 $280.00
VX9900 $329.00

A1:B4 D1:E3


Create a cell (A6) for Product entry using Data Validation witl List:
=Product and one for Plan (C6) with list: = Plan

A third cell has your price (E6).

In the result cell (F6 in my example) put:

=VLOOKUP(C6,PlanTable,2,0)-VLOOKUP(A6,ProductTable,2,0)+E6

where C6 (in my example) is the Plan, A6 is the product and E6 the price

Product Plan
Price Result
VX8500 $34.99-$59.99 $100.00 $130.00

A6 C6
E6 F6

HTH