Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Based on Other Selection
Hi,
I have created a drop down menu in a cell based in content in another worksheet. I'd like the adjacent cells to auto populate based on the selection in the drop down. How do I do this? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Based on Other Selection
use VLOOKUP
-- Gary''s Student - gsnu200721 "Kate" wrote: Hi, I have created a drop down menu in a cell based in content in another worksheet. I'd like the adjacent cells to auto populate based on the selection in the drop down. How do I do this? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Auto Populate Based on Other Selection
Kate
Probably by using a lookup table and VLOOKUP formulas which return the data based upon an ID number or similar. 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 Tue, 15 May 2007 13:09:00 -0700, Kate wrote: Hi, I have created a drop down menu in a cell based in content in another worksheet. I'd like the adjacent cells to auto populate based on the selection in the drop down. How do I do this? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
How do I Auto Populate a cell with a chart based on a value | Excel Worksheet Functions | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
HOW ?Excel chart auto insert /populate a code based on date | New Users to Excel | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) |