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...
For such sample model
formula in H3 could be
=IFNA(
INDEX(
$B$5:$D$46,
MATCH(G3,$A$5:$A$46,0),
MATCH(1,INDEX((F3>=--LEFT($B$4:$D$4,2))*(F3<=--RIGHT($B$4:$D$4,2)),0),0)
),
"no such")