# Apply grading scale Vlookup depending of a criteria M or F

Hello Glide Community,

As PE teacher, I want to apply a grading scale depending of the gender in Track & Field.
So with the Vlookup fonction I can apply the grading scale but I’m not able to figure out how to apply a different grading scale depending of the gender data (M or F) already in my sheet.

I created 2 different sheets for the M grading scale and the F grading scale but how to have

So for instance John (M) run the 400m in 67 seconds but Mary (F) runs in 77 seconds with my 2 grading scale they should have the same grade but as I cannot do the Vlookup with the criteria M or F the result is not the good one for John or Mary

My formula in google sheet works but I want to do it in my Glide App => =IF(\$Q\$1,TRUE)*VLOOKUP(N41,‘SCALE M’!\$A\$2:\$B\$36,2,1)+IF(\$N\$1,TRUE)*VLOOKUP(N41,‘SCALE F’!\$C\$2:\$D\$36,2,1)

Do you have a dummy sample of your data? Thank you.

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:

1 Like

Hi,

Thank you for your answer. I put a sample of my with my 2 issues

• first I can only apply one SCALE to my race results and not apply the FEMALE SCALE or MEN SCALE depending of the gender column
• second is the lookup because if the time in the results is not matching exactly the scale no grade appear. In Google sheet the Vlookup will reach the closest number but not in Glide