Put this formula in cell C3 and copy down to the end of the data in Column A...
=B3*VLOOKUP(A3,V$2:W$24,2,FALSE)
Hi, Rick!
First off, thanks so much for the reply, I really appreciate any help I can get.
I tried what you suggested, and it took a little tweak to get it to work, but once I did, I realized it's not quite what I'm looking for, and it's made me realize I should probably explain what this spreadsheet is in slightly greater detail.
Basically, I (and many other athletes) will be using this spreadsheet to make it easier to "program" our daily workout and weightlifting routines ("Olympic" Weightlifting, the sport.)
There will be a repeat of the two header rows you see ("Date", with "lift, %, KG, Reps & Status, Comments") followed by 10-15 rows of "Lifts" with percentages in B, and set/rep/status in D-S.
The problem I encountered with your solution is that it seems to assume things work from left to right in this sheet; they do not.
Columns V & W are a record of the athlete's maximum, or "personal record" (PR) for any given weightlifting movement.
Column A is meant to be part of their daily routine, in which they are told to do a certain "lift"
Column B is the percentage of their "Max/PR" for that lift
Column C will multiply column B and whatever cell in column W that shares the same text as the cell to the immediate left (in column A) of the cell in column B
Column V & W will be frozen/static; these are meant to be 20-30 cells which will only change once every couple months, while column A & B will constantly draw from their data, for several thousand cells.
....I may have overcomplicated the explanation, but I wanted to be as clear as possible. Thank you again for any assistance you can offer me!
