I'd like to use a VLookup formula to make a List to be used in a Data Validation situation. So, if a hotel is selected in one cell, the next cell will automatically have a list to select from of the people who work there.

It appears that VLookup will only look up one cell and even if I put a delimited list in that cell (e.g. names separated by comma) this doesn't work.

Any Ideas?

Steve
steveseattletours@yahoo.com