Forum Discussion
PLEASE HELP!!! How do I track data without formulas?
HansVogelaar Are you saying the MATCH and INDEX Formulas are able to look-up the exercise, no matter which row it appears in under Column A? So if squats appears in cell A4 or cell A16, the MATCH and INDEX Formula will still find the squats as long as it's under Column A? But in order to do that, I would have to put the MATCH and INDEX Formulas into every single cell under Column A, right?
So I'd have to create a MATCH and INDEX Formula for each of the 7 key exercises (squats, bench, deadlift, rdl, hip thrust, ceiling row, wide-grip lat pulldown). And they would all have to be under Column A because that's where the exercises will appear. But am I able to create 7 versions of the same formula for 7 different exercises, all under the same column (column A)?
You only need to create the formula in one cell, then fill it down to the cells below.
For example if a simplified Workouts sheet looks like this:
Formulas on the other sheet:
I entered the formula in B2, then filled it down to B8.
Note that the exercises are listed in a completely different order on the Workouts sheet.
THIS IS THE LINK TO THE DOCUMENT in Microsoft One Drive. You can edit it with this link too.
https://1drv.ms/x/s!AsqZsxCjbfE2yyb7O56GmSse8zY9?e=NzOTEb
Could you add a few dummy data to the Workouts sheet, please, so that I have something to work with? Thanks in advance.
HansVogelaar Absolutely I can do that. Here it the sheet with example data in it. I also created a new sheet in it called "TRACKABLE EXERCISES" which has the exact names of the exercises that need be "trackable" for the purpose of this workbook. Which we've been discussing since the beginning. THANK YOU SO VERY MUCH!!!! Here is the link to the file in Microsoft One Drive.
WORKOUT SHEET WITH EXAMPLE DATA INCLUDED BELOW:
https://1drv.ms/x/s!AsqZsxCjbfE2zhJ70mmLg6Dcw2l5?e=KxqYU6