Data Validation Lists - Generating a list based on another list's result

Data Validation Lists - Generating a list based on another list's result

Post by Daniel Gra » Sun, 14 Mar 2010 07:21:01


I have been searching the web all day, and I am not sure how to
approach this problem. Here is a basic worksheet:

ID Name Serial #
1 Joe ck9033n2389d
2 Joe 349-283fjrjh55
3 Bob c90320j34n5kjdf
4 Joe kgho95injhs
5 Bob 2353gdf745

Step 1: I have a drop down list with only one instance of each of the
"Name" variable.
Step 2: Upon selecting that name, I would like another drop down box
with all the serial numbers associated with that person.
Step 3: Then, based on the serial number, display stats in the same
row for that item.

Step 2 is what I am having problems with. Any direction would be
extremely helpful. VB? Access? A formula I can't think of?

I would be greatful for any help you could provide.
 
 
 

Data Validation Lists - Generating a list based on another list's result

Post by dan dunga » Sun, 14 Mar 2010 07:39:18

Hi Daniel

Have a look at http://www.yqcomputer.com/

Dan

 
 
 

Data Validation Lists - Generating a list based on another list's result

Post by L. Howard » Sun, 14 Mar 2010 08:17:36

In addition to Dan's D suggestion, you will probably need to use VLOOKUP to
match up the stats for a particular serial number. Where you would have a
list of the serial numbers in a table say, column J and the stats in column
K, L. M

=VLOOKUP(F1,K1:M100,2,0)

Would return the stat for the serial number in F1 from 2nd column of the
table, K. Change the 2 in the formula to 3 and it will return the 3rd
column value in L. 4 returns M.

HTH
Regards,
Howard