LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 55
Default Displaying a result based on user selection

I need to display a result based on what a user selects from a list of options.

Example:

Selection A - Make of car
Mazda
Ford
GMC
Porshe
Toyota

Selection B - Number of Doors
2
4
5

Result possibilities:
If the user selects Ford and 2 door then the result would come up with an
F-150.
If the user selects Mazda and 5 door then the result would come up with a
Mazda 3.
etc.

How do I do this. I can create drop down lists and list boxes, or control
boxes to show the Selection A & B however I don't know how to get it to
display the results based on the selection.

Thanks for your help!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Displaying Drop down list items based on selection of another colu myssieh Excel Discussion (Misc queries) 3 February 18th 08 02:15 PM
The Formula is displaying, not the result tcarp Excel Discussion (Misc queries) 6 January 30th 07 06:51 AM
Calculate average based on user selection William Excel Discussion (Misc queries) 2 January 16th 07 06:16 PM
Hiding worksheets based on user selection HL Excel Worksheet Functions 3 October 12th 06 04:01 PM
vlookup based on random result returns incorrect result rickat Excel Worksheet Functions 1 December 6th 05 01:16 PM


All times are GMT +1. The time now is 11:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"