Forum Discussion
PLEASE HELP!!! How do I track data without formulas?
Hello. I have created an advanced Excel Workbook for tracking client's workouts. I can input exercises and the data, such as the weights you lifted and the reps you did. HERE'S THE PROBLEM WITH IT. T...
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.