Formula Help / Worksheet Help

  • Thread starter Thread starter LTOSH
  • Start date Start date
L

LTOSH

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
 
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
 
Back
Top