Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull down selections
How do I display values or text in other cells when making a selection from a
pull down menu that applies to that selection? Say for instance I select pizza out of a selection of food options and next to that pull down menu is a column for grams, one for calories and one for fat content. I want to know how to display that information for pizza? -- Thank You. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pull down selections
You could use VLOOKUP formulas in the appropriate cells to pull grams, calories
and fat content. See Debra Dalgleish's site for more on VLOOKUP and Data Validation lists for entering the choices. http://www.contextures.on.ca/xlFunctions02.html http://www.contextures.on.ca/xlDataVal01.html Note the section on using DV lists from another worksheet by naming the list. Gord Dibben MS Excel MVP On Wed, 17 Oct 2007 09:55:02 -0700, McIntosh wrote: How do I display values or text in other cells when making a selection from a pull down menu that applies to that selection? Say for instance I select pizza out of a selection of food options and next to that pull down menu is a column for grams, one for calories and one for fat content. I want to know how to display that information for pizza? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array selections | Excel Worksheet Functions | |||
Multiple selections | Excel Discussion (Misc queries) | |||
Using selections in VBA | Excel Discussion (Misc queries) | |||
help with selections | Excel Discussion (Misc queries) | |||
List Box Selections | Excel Worksheet Functions |