Hi everyone,
Ive encountered an issue where the index match function finds the same number causing it to skip a value and gives me the wrong one.
Hopefully the following images makes it clearer than my wording.
Reference Table.JPG
This is the table reference, i have assigned a percentage score in the first column and the equivalent score in the second column.
The formula i used:
Formula:Please Login or Register to view this content.
For some reason, the results for 0.14 and 0.15 comes to the same percentage score of 7.40% and this causes a skip in the sequence and i am not getting the 10% percentage score if the result is at 0.4.
I have tried almost everything, using different excel, using fixed values, adding the match type 0 - exact value for the above formula and still could not find a solution.
If it helps, i used the same formula but with a larger table and it came out correct, i only see this issue with the smaller sample sizes.
Appreciate any help i can find, thanks.
Bookmarks