Validation Question

[KLock]

On one tab I have a table setup with business and questions (with different
questions for each business).
Business Question
Ride Ques1
Ride Quest2
Ride Quest3
Food Ques1
Food Ques1
etc.

On the second tab I have a validation list for each business. Below that
cell I would like to have a drop down list of each question depending on the
business chosen.
CellA1: Choose a business
CellA2: Choose the question

Is there a way to write a vlookup formula or something along those lines in
a validation list for CellA2?

Must be done in Excel, though I do know that if done in access I could have
written a form and subform.

Thanks for any help

 

[Debra Dalgleish]

There are instructions here for creating dependent data validation drop
downs from a sorted list:

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

 

[KLock]

Thank you this is exactly what I was looking for

There are instructions here for creating dependent data validation drop
downs from a sorted list:

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



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com