Index Match not working for specific cells in an array

Hello,

I am trying to use index match for calculations around a percentage of a given number. This is primarily because I am trying to get more of a feel around using Index Match in general, not necessarily to be as efficient as possible.

In this attachment, I am trying to index match a certain result given a few IF statements.


The logic behind this is: If the number of total reps hit is between this range, then you increase the weight by a certain percentage from week to week. However, once I have the percent increased found, the next weeks index match is returning an error only for certain numbers which from what I can tell, are in the array. Also, if I add a column next to the calculated cell and use the NUMBERVALUE formula to on the cell and use the new NUMBERVALUE driven cell, the index match function works.

I am attaching the spreadsheet with sample data if anyone could help explain why this N/A pops up. That would be awesome.

Great! That makes sense. I will give that a try. Thank you!

as a way
=INDEX('Percentage Lookup'!$G$20:$U$43,MATCH(J9,'Percentage Lookup'!$E$20:$E$43,),MATCH(K9,'Percentage Lookup'!$G$19:$U$19))