I have two table that are not linked and one measure

I Would like to add another measure that basically look at the achievement from Score table and pick up the corresponding Mark from Banding Table

Any ideas please ?

Thanks

powerpivot Scoring band.PNG