I would like to know the answer to this question as well. Has anyone
answered it somewhere else? I have been seeking this answer for some time
now. I finally posted my own question but noone seems to be able to
understnad what I want done. This is simply put what I am looking for.

marcus

"PJ, a guy in need of help" wrote:

Currently i have a list made up by the validation feature but i have another
list to correlate to that. I have about 50 items in both lists and need them
to connect together. What I need is when you choose from the list dropdown
that the correlating cell/will go with that and fill in the next cell to the
right of the list option you selected. Can anyone help.

Thanks

PJ