I don't think you need VBA instead do with formulas in Excel
I would have 3 worksheets labled Table,Scores, and Interpretation
Note the number 3, 7, and 11 in column A.
I would leave column A empty on the other two worksheets so data is in the
same column on each worksheet.

Table worksheet
A B C D E F thru L
same as previous

1 3 A-Low B-Low C-Low D-Low


2 7 A-Med B-Med C-Med D-Med


3 11 A-Hi B-Hi C-Hi D-Hi



Scores
A B C D E F thru L
same as previous

1 Scores Scores Scores Scores


2 Scores Scores Scores Scores


3 Scores Scores Scores Scores


Interpretation (fil with formulas below table)
A B C D E F thru L same
as previous

1

2

3

enter B1 and copy to B2 and B3
formula for B1 =lookup(Scores!B1,Table!$A$1:$L$3,2,False)
Formula for B2 =lookup(Scores!B2,Table!$A$1:$L$3,2,False)
Formula for B3 =lookup(Scores!B3,Table!$A$1:$L$3,2,False)

Copy B1 to C1 thru L1
C1 change 2 to 3, then copy C1 to C2 and C3
Similar to above but "2,false" changes to "3,false"
formula for C1 =lookup(Scores!C1,Table!$A$1:$L$3,3,False)
Formula for C2 =lookup(Scores!C2,Table!$A$1:$L$3,3,False)
Formula for C3 =lookup(Scores!C3,Table!$A$1:$L$3,3,False)

D1 change 2 to 4, then copy D1 to D2 and D3
Similar to above but "3,false" changes to "4,false"
formula for D1 =lookup(Scores!D1,Table!$A$1:$L$3,4,False)
Formula for D2 =lookup(Scores!D2,Table!$A$1:$L$3,4,False)
Formula for D3 =lookup(Scores!D3,Table!$A$1:$L$3,4,False)

continue to column L is simialr fashion