Apply grading scale Vlookup depending of a criteria M or F

[M_Rom]

I think @Robert_Petitto has some solid solutions to this based on his gamification app. No need to use VLookup
My app is completely different from this but it gave me some great ideas:

How To: Build a Gamified Glide App (updated 10/6/20)

Learn to create a gamified Glide app from scratch! Complete with XP, in-app currency, ranks, progress bars, guilds, challenges, inventory and item stores. Part 1: Create your spreadsheet, design an onboarding experience, set up user profiles, and add users to guilds! [Gamify your Glide App #1: Onboarding, User Profiles and Guilds]