I have a list of percentages starting from say 5% to 70% in increments of 5%, I would like to use the match function to obtain the row number associated with a particular % in the range. The issue I am having is when I look for 15% it gives me an error (when it should give me 3) but when I look for say 20% it gives me the correct answer as 4. Can you please help, I don't understand why I am getting this error. Its driving me crazy.
I also tried doing a Vlookup by creating a column next to the cells from 1 to say 4, then run a Vlookup for 15%, I get the same error. What am i doing wrong?
I also tried doing a Vlookup by creating a column next to the cells from 1 to say 4, then run a Vlookup for 15%, I get the same error. What am i doing wrong?