help with worksheet design
 

I have a workbook with 2 worksheets...Worksheet 1 'Workout'...Worksheet 2
'Exercises'. Worksheet 1 I have set up to pull data from Worksheet 2 to
compete a workout form. The setup of 'Exercises' worksheet is as follows
(Category, Chest, Abs) columns as named ranges...see example...
Categry Chest Abs
Chest Chest Flye Reverse Crunch
Abs Bench PRess Basic Crunch

In my 'Workout' w.sheet i have a data validation drop down choosing
'category', then a vlookup based on that choice showing the exercises that
match the Category in a row. All of this is working fine...however here is
my dilema....

I am wanting to have a column for 'Description' in my 'Exercises' worksheet
to list the description for the exercises but I can't figure out how to input
this data to match this specific exercise. I want this data to be
automatically inserted in my 'workout' based on the exercise chosen.

I hope this makes sense...any help or direction is appreciated.
Thanks!!!

help with worksheet design
 

P.S. I wanted to add that I have attempted to set up my 'Exercise' worksheet
like this...
Column 1 = Category (chest, leg, ab)
Column 2 = Exercise
Column 3 = Description

which makes more sense to me in trying to associate the exercise with the
description but i could not get the formulas correct on my 'workout' w.sheet
to give me a drop down of the categories, then be able to pick just the
exercises from that chosen category. It would only match row by row.

help!

"LTOSH" wrote:

I have a workbook with 2 worksheets...Worksheet 1 'Workout'...Worksheet 2
'Exercises'. Worksheet 1 I have set up to pull data from Worksheet 2 to
compete a workout form. The setup of 'Exercises' worksheet is as follows
(Category, Chest, Abs) columns as named ranges...see example...
Categry Chest Abs
Chest Chest Flye Reverse Crunch
Abs Bench PRess Basic Crunch

In my 'Workout' w.sheet i have a data validation drop down choosing
'category', then a vlookup based on that choice showing the exercises that
match the Category in a row. All of this is working fine...however here is
my dilema....

I am wanting to have a column for 'Description' in my 'Exercises' worksheet
to list the description for the exercises but I can't figure out how to input
this data to match this specific exercise. I want this data to be
automatically inserted in my 'workout' based on the exercise chosen.

I hope this makes sense...any help or direction is appreciated.
Thanks!!!