Data Validation Lists - Generating a list based on another list'sresult

[Daniel Gravenor]

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.

 

[dan dungan]

Hi Daniel

Have a look at http://www.contextures.com/xlDataVal02.html

Dan

 

[L. Howard Kittle]

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