Here's one I liked and am using.

http://www.contextures.com/xlDataVal13.html

BUT - I need more help.

I have a table of available values with columns for name and ID

Name - ID
Joe Smith 1234567890
Suzy Jones 2234567890
etc.

I want a user to be able to select the NAME in the drop down, but at the same time I want the ID to also populate in another column of the same row.

I WAS putting the name in the validated drop-down cell and then going back to search for the ID based on name, but that won't work 100% because names aren't unique.

I also thought of just concatenating the Name and ID and putting them in the same field.

I don't really do VBA, but I'm fearless with formulas.

Any ideas?

bibere usque ad hilaritatem