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.

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!

help with worksheet design
 

need to make a correction to my information below...second paragraph...
column 1...i have a data validation with source - 'categories'
column 2...then i have a data validation with source - =indirect (a5) that
pulls information from the categories list depending on what category is
chosen

"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.

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!

help with worksheet design
 

so it your data is in a table and you're uising vlookup to get the excercide,
why don't you use vlookup to get the description?


"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.

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!