Need help with conditional lists in excel
February 23, 2013 3:06 PM Subscribe
I'm creating a workout training program in excel, and I want to show a range of data based on certain conditions. Using Excel 2010 More after the jump.
posted by FireStyle to computers & internet (9 answers total)
This is how far I've gotten so far:
On cell B1 I have a category "Workout Type", and on cell C1 I have a drop down list of different workouts (Full Body, Chest, Back, Triceps, etc.)
On another sheet (sheet2) I have a list of the workout order:
Back to Sheet1, I wanted to create a condition, if B3="full body", return the items in sheet2!B13:B21.
What I have ALMOST works. My formula so far is:
=IF(B12="Full Body",(Sheet2!B13:B21),"select workout")
Select workout is a temporary false statement.
Now what happens is, the argument B13:B21 only returns the value of B13 (Chest)
How do I get excel to show the contents of B13:B21?
Thanks much, and I hope that makes sense!