IF male or female IF age is in range...THEN...

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

Hi Josh,

Yes ... it is feasible ...

It is a two step process ...

1. You do have to type in all your reference tables

2. A VLOOKUP() function will do the search and retrieval from your reference tables

HTH
Carim