Generate list based on drop down selection

Closed
stella - Apr 14, 2010 at 06:18 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 15, 2010 at 11:45 AM
Hi,

I am trying to get a list of data to update cells upon the selection of a drop down menu item, which will vary.

For example, , Sheet 1 Cell A1 has the name of the state that would be selected. I would then want to search for this value in Cell A2 and find associated people and copy that information back to Sheet 1 Cell C3 for as many records as it would find.

The data would look like this:

Drop down: VIC TAS SA WA in sheet 1 cell A1
Look up selection in Cell A2 & copy people for VIC.


1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Apr 15, 2010 at 11:45 AM
Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to get a better understanding
0