Add a code to select between men and women for different category

[AlexiaDin]

Hello everyone!

I have the following information:
Date of birth, age, gender and different categories.

I want the code to take the date of birth and the gender information and select the respective category. I already did it for the Men. However, excel is putting everyone like a Men and I want it to separate men and women.

I want to create the following categories:

For Men:

Pre poussin
Poussin
Benjamin
Minime
Cadet
Junior
Senior
Veteran

For women:

Pre poussine
Poussine
Benjamine
Minime F
Cadette
Junior F
Senior F
Veteran F

Which code do I need to add in order to recognise as women and add it to the good category?

Here is the excel file: Stats.xls

If you have any suggestions, please let me know.

Thank you!!

[Glenn Kennedy]

One way:
=IF(A2="","",INDEX($H$2:$I$9,MATCH(YEAR(A2),$G$2:$G$9,-1),MATCH(C2,$H$1:$I$1,0)))

see file.

[Glenn Kennedy]

BtW... You have O365, why are you using the OBSOLETE .xls extension?