Linking Named Lists

[mwhite18]

I have searched unsuccessfully for an answer to this question. I have to rows of lists, one names of clients the other an identifying ID. I use the ID to look up statistics about the client.

I want to have a drop down list of client names that are linked to the adjacent ID, so when a client name is selected, the ID in the adjacent list is selected as well.

[Gatti]

If the clients list is in B and ID list is in A

Lets say your DropDown Cel is in C1

Then, the Formula will be:

Please Login or Register  to view this content.

[FDibbins]

Not sure what you mean by "so when a client name is selected, the ID in the adjacent list is selected as well".

I have a feeling that gatti is on the right track here. HBowever, it would probably help a lot if you could give some examples of what you have - and what you want