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 with hidden values 1
referencing a Drop Down Menu 1
Use Contents of Drop Down List 3
Excel Drop Down Box 2
Adding Values To Drop Down Menu 1
How to equate Text Drop Down selections to numerical values 3
Data validation list drop-down values based on prior selections 2
Filtered Drop Down Menu Based on Previous Drop Down Selection 1

Top