ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Auto Populate Based on Other Selection (https://www.excelbanter.com/excel-discussion-misc-queries/142842-auto-populate-based-other-selection.html)

kate May 15th 07 09:09 PM

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!

Gary''s Student May 15th 07 09:16 PM

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!


Gord Dibben May 15th 07 10:57 PM

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!




All times are GMT +1. The time now is 07:21 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com