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
"Daniel Gravenor" <(E-Mail Removed)> wrote in message
news:aa2d99e0-4974-4c2e-a09d-(E-Mail Removed)...
>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.
|
Similar Threads
