Forum Discussion
Solved
Trying to sum up textual grades into total sum to be paid
So bassicaly what i'm trying to do is, i have my scorecards and employee grades up (the tables are relatively large and are divided into weeks and hence, different sheets). What i'm trying to do now ...
I created a table named Scores with two columns: Grade and Score. It can be on the same sheet or another sheet.
This can be used in an XLOOKUP formula:
The formula in C2 is
=XLOOKUP(B2:B9, Scores[Grade], Scores[Score], 0)
I created a table named Scores with two columns: Grade and Score. It can be on the same sheet or another sheet.
This can be used in an XLOOKUP formula:
The formula in C2 is
=XLOOKUP(B2:B9, Scores[Grade], Scores[Score], 0)