Filter on a list then make a calculation - help with formula

[calvares]

I am developing a marking form using a customised SP list. The marker selects from a drop down for different criteria - excellent, very good, good etc. The grades are linked to percentages e.g exceptional is 90%. I have these tabled in another SP list called 'Grades'.

I then want to convert these grades into actual numerical marks which will involve selecting the percentage then multiplying it by the weighting for that category. I have a numerical field for each category (mark1, mark2, mark3 etc) in the main data source which I want to set to this calculated mark. I'm presuming I need to filter on 'Grades' first - Title in this list is in the datacardvalue.selected.value, and then I want only Percentage in Grades. Once I have that percentage I want to multiply by 0.16 for example.

I'm a bit stuck on how to put this formula together though!

[calvares · Accepted solution]

OK I may have worked it out. Formula I have used is:

LookUp(Grades, Title in DataCardValue9.Selected.Value, Percentage) *0.16