assign Drop Down selections with values

  • Thread starter Assigning drop down selections w / Value
  • Start date
A

Assigning drop down selections w / Value

Not sure if this can be done..

Looking to assign drop down selections a "value" for which, once selected,
can be multiplied by different cells to come up with an extension.

More like assigning a menu of words with a value and then once user selects
that specific item along with another drop down value, an extension appears.

For Example

Tickets to Rome- $590.00 each
Tickets to Paris- $400.00 each
Tickets to New York-$320.00 each

Multiple by:
1 Round Trip Passenger
2 Round Trip Passengers
3 Round Trip Passengers

Equals= Extension.

Possible through Excel?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Drop Down with hidden values 1
referencing a Drop Down Menu 1
How To Clear Drop Down Selection 0
drop down menu with option to add values to the list w/ new entry 0
Insert new row with drop-down box but problem with cell linkreferring to the original drop-down box 2
Excel Drop Down Box 2
Help with drop down selection and populating related data... 9

Top