Dear kind Excel community,
Please see sheet attached. I wish to fill Cell L4.
L4 should provide me with a distance category value specific to the distance covered AND the position of the rugby player. For example, a Prop who has covered 15,500 metres should be in the MH (moderate-heavy) category, because the category goes from 15068m to 17307m.
If I was to change the position in Cell L2 to 'Centre', the category for 15,500m covered would become ML.
I have tried various Index-Match-Match formulas and found no joy.
Please may I have some help?
Many thanks
George
Bookmarks