Forum Discussion
PLEASE HELP!!! How do I track data without formulas?
You can probably use a combination of INDEX and MATCH.
Let's say that A2 on the Weekly Results sheet contains SQUAT.
The row within A5:A16 on the Workouts sheet containing SQUAT is returned by
MATCH(A2, Workouts!$A$5:$A$16, 0)
The corresponding value in for example F5:F16 is
=INDEX(Workouts!$F$5:$F$16, MATCH(A2, Workouts!$A$5:$A$16, 0))
See if you can take it from there.
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.