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

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

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

KLock wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

Thank you this is exactly what I was looking for

"Debra Dalgleish" wrote:

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

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

KLock wrote:
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
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com