Hello,

Hopefully someone cant help me whit the following problem.
In a competition I am in your Total score is corrected based on your Gender and Weight by means of a coefficient.
Currently this is all calculated by hand because I cant figure out how i can let Excel select the applicable Coefficient.

Please have a look at the attachment, will probably give you a much better idea of what I'm wanting to do.
The values in RED are the expected results when i multiply the Total by the relevant Coefficient.

Any and all help much appreciated.

Example Sheet.jpg