OK so I'm completely new to all this but I've taken on a challenge to try to create a spreadsheet to evaluate fitness data. I'll try to explain this the best that I can.

Males and Females are evaluated on different critera as are different age groups. My end goal is to figure out what percentile each candidate falls in.
For example MALE --> 29 years old --> 60 pushups --> puts him in the 80th percentile. I have hard copies of all the tables show what percentile each candidate falls based on age and gender. Is this even possible? Should I create multiple spreadsheets? I guess what I am thinking is that if I enter MALE on a drop down menu the formulas for the rest of the sheet would change...then when I select the age range the formulas will change again. Then they will pull from the corresponding table. I hope this makes any sense at all. If anyone can offer any advice it would be greatly appreciated.
Thanks in advance.

Josh