Forum Discussion
VLOOKUP using user input to determine column
Step1: User inputs data Step 2: User input is transferred to 2nd table Step 3: Score column references 2nd sheet(Pushup) table to determine score. Uses reps to determine row and age for the column...
Thank you for taking time to respond. My apologizes for not attaching the file( you will find it attached to this reply). I attempted to input your formulas into my sheet referencing your example, however for some reason it didn't work, most likely due to an error on my part. You will find my attempts to apply your formulas on the results sheet in the pushups score column. Further help would be greatly appreciated.
In the attached version of your file, the formula in G4 is:
=VLOOKUP(F4,Pushup!A$5:R$82,
MATCH(C4,INDEX(--LEFT(Pushup!B$4:I$4,2),
0),1)+1+9*(B4="F"),0)
Note that the formulas in I4 and K4 are similar to the foregoing. Please confirm if such formulas return your expected results.