# Apply grading scale Vlookup depending of a criteria M or F **URL:** \ **Category:** Ask for Help\ **Created:** [November 13, 2020, 3:14pm UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355 "2020-11-13T15:14:25Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Joseph\_Leblanc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_leblanc/32/16002_2.png) [@Joseph\_Leblanc](https://community.glideapps.com/u/Joseph_Leblanc)\ **Post date:** [November 13, 2020, 3:14pm UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355/1 "2020-11-13T15:14:25Z")
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) Thank you for your help and or advice ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [November 13, 2020, 3:38pm UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355/2 "2020-11-13T15:38:51Z")
Do you have a dummy sample of your data? Thank you. ---
**Author:** ![M\_Rom](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/m_rom/32/340_2.png) [@M\_Rom](https://community.glideapps.com/u/M_Rom)\ **Post date:** [November 13, 2020, 3:39pm UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355/3 "2020-11-13T15:39:53Z")
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)](https://community.glideapps.com/t/how-to-build-a-gamified-glide-app-updated-10-6-20/13102): > > 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] ](https://www.youtube.com/watch?v=2RrwaKKcm00) ---
**Author:** ![Joseph\_Leblanc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_leblanc/32/16002_2.png) [@Joseph\_Leblanc](https://community.glideapps.com/u/Joseph_Leblanc)\ **Post date:** [November 13, 2020, 8:55pm UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355/4 "2020-11-13T20:55:38Z")
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 > **[GRADE RACE GLIDE](https://ashamed-pen-7236.glideapp.io/)** Thank you for your help ---
**Author:** ![Joseph\_Leblanc](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/joseph_leblanc/32/16002_2.png) [@Joseph\_Leblanc](https://community.glideapps.com/u/Joseph_Leblanc)\ **Post date:** [November 18, 2020, 3:47am UTC](https://community.glideapps.com/t/apply-grading-scale-vlookup-depending-of-a-criteria-m-or-f/18355/6 "2020-11-18T03:47:52Z")
So I found a solution to fix my issue because I was not able to apply to True False in addition to lookup even with the help of the glide app community. I get around my problem (not by the easiest way or fastest way), by generating two different columns from my general time race results column. Depending on the gender M or F with the function If-then-else it puts all Male results in one column and all women results in another column. After that I applied my Male grading scale with a relation function to the column with Male results and I did the same thing for the women grading scale using a relation. It works but I still don’t understand why and how I cannot apply/add a basic True/False function with the glide app lookup function… like in my Excel/Spreadsheet formula shown at the beginning. Hope it helps someone with my beginner level