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! |
Displaying a result based on user selection
See Debra Dalgeish's site for instructions for creating dependent DV lists.
http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 09:16:02 -0700, Emma wrote: 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! |
Displaying a result based on user selection
Or maybe a combination of two dependent lists and a VLOOKUP formula?
See also Debra's site for VLOOKUP http://www.contextures.on.ca/xlFunctions02.html Gord On Tue, 09 Jun 2009 09:50:53 -0700, Gord Dibben <gorddibbATshawDOTca wrote: See Debra Dalgeish's site for instructions for creating dependent DV lists. http://www.contextures.on.ca/xlDataVal02.html Gord Dibben MS Excel MVP On Tue, 9 Jun 2009 09:16:02 -0700, Emma wrote: 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! |
Displaying a result based on user selection
Hi Emma,
I think what you will need to do here is a Double Lookup. Follow the following link to Chip Pearson's web page. He gives a great example of a double lookup. http://www.cpearson.com/Excel/TablesAndLookups.aspx Please press Yes if this helped you. John "Emma" wrote: 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! |
All times are GMT +1. The time now is 01:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com