Formula Help / Worksheet Help
 

Let me set this up before I ask my question.
I have a worksheet 'Exercises' that has multiple columns of information.
Column A (Categories) Column B (Legs) Column C (Abs) Column D (Chest)
Legs Leg Press Basic Crunch
Chest Press
Abs Leg Extension Reverse Crunch
Front Lat Raise
Chest Lunges V-Sit UP
Side Lat Raise

I have a second worksheet "Workout" that has the following already set up.
I have in A12 a Data Validation (List...Source=Categories) that gives me the
list from COlumn A (Categories)
I have in B12 a Data Validation (List...Source=INDIRECT(A12) that gives me
the list of exercises based on the choice from A12.

With that set up here is my desire and question. I want in C12 a
description of the exercise chosed from B12 to automatically pop up. My
question is where in my "exercises" worksheet do I put the inforamtion (ex.
ChestDescription) and what is my formula to make this happen?

please help.
thanks

Formula Help / Worksheet Help
 

Let me fix these columns better...didn't show like it should have in post...
Column A (Categories) Legs Abs Chest
Column B (Legs) Leg Press Leg Extension Lunges
Column C (Abs) Basic Crunch Reverse Crunch V-Sit Up
Column D (Chest) Chest Press Front Lat Raises Side Lat Raises

"LTOSH" wrote:

Let me set this up before I ask my question.
I have a worksheet 'Exercises' that has multiple columns of information.
Column A (Categories) Column B (Legs) Column C (Abs) Column D (Chest)
Legs Leg Press Basic Crunch
Chest Press
Abs Leg Extension Reverse Crunch
Front Lat Raise
Chest Lunges V-Sit UP
Side Lat Raise

I have a second worksheet "Workout" that has the following already set up.
I have in A12 a Data Validation (List...Source=Categories) that gives me the
list from COlumn A (Categories)
I have in B12 a Data Validation (List...Source=INDIRECT(A12) that gives me
the list of exercises based on the choice from A12.

With that set up here is my desire and question. I want in C12 a
description of the exercise chosed from B12 to automatically pop up. My
question is where in my "exercises" worksheet do I put the inforamtion (ex.
ChestDescription) and what is my formula to make this happen?

please help.
thanks