Forum Discussion
Finding the Right Excel Formula and putting it together
Hi All, This is my first time using this forum but I've hit a roadblock. I'm trying to create a tool/calculator for the line of work which is scouting football/soccer players across the world and to...
ozzie4khawaja Since you indicated to be a MS365 subscriber, you can use INDEX and XMATCH to achieve your goal, fairly easily, as demonstrated in the attached workbook and on the basis of the scoring table in your screenshot. I changed the column and row headers to numbers, though.
Riny_van_Eekelen Hello Rinky, thank you so much for providing your workbook, it seems like most of the example you provided works however I checked that if the player scores 5% playing time with a ranking of 1, it comes back with 0 points when it should come back with 8 points.