Issues with Match function, Please Help

mehtap3

New Member
Joined
Jul 18, 2013
Messages
6
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 entered into Cell A2 =A1+0.05

and then copied it down to A14

Have to modify formula to: =MATCH(C1,$A$1:$A$14,1)


Thanks Jim, that works for now. I might have to control the input so users don't insert numbers that are outside the list.
 
Upvote 0

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,223,911
Messages
6,175,337
Members
452,637
Latest member
Ezio2866

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top