Having a problem with the =IF male/female formating and vlookup...

My assessment data is styled as the following,

[If male or female], [resulting heartbeat bpm after test], and [age related to expected heartbeat ranges], and answers [below average, average, and above average] accordingly.

I got the vlookup without a problem. It’s the male or female and their separate corresponding tables that I am not getting right.

Would someone kindly write me an example of the formula that may help me. Thanks so much!