BigBas

You helped me with a criteria=depedant population of a linked combobox. I was hoping you could expand my knowledge a little

http://www.excelforum.com/excel-prog...ml#post2068716

I just posted a reply to you. Please look at my thread "Ctrl + Home to have the first cell selected"

Hi. I read an answer you posted and thought you might know a solution to a problem I have.

I want to be able to combined the VLOOKUP and list functions.

For example:
- column 1 is 'job titles'
- column 2 is 'names'

I specify the job title, and then excel creates a drop down menu of every name that matches that title.

I hope that makes sense. I cannot figure out how to pull this off as the list functionality seems very limited.

Any thoughts? I would sure appreciate your help.

-Scott