match #value!

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...

Hello all, I have a problem and I hope you can help. I'll try to explain it as clearly as possible. I have two columns with textual values in them. The values are similar, but not 1:1 identical. For instance, what is called in one column "I'm cell number 1" might be called in the other column...

Hi! My table looks this: <tbody> x y z aa ab 100 Client Jan-12 Fev-12 Mar-12 Apr-12 101 aaa 1 1 3 1 102 bbb 3 2 1 2 103 ccc 1 2 1 2 104 ddd 4 4 3 4 105 eee 5 4 5 4 106 fff 5 6 5 6 107 ggg 5 6 7 6 108 hhh 5 8 8 8 </tbody> For Jan-12 I would get this information...

First off; I'm sorry I dont have any example code since I'm unsure to how tackle this issue. As per today I have a nice little code which imports data from a mastersheet to my input sheet. Though it will only work as long as the mastersheet is static. I'm trying to match the product code in...

Hello, What formula can I use to match B1 value with A1 only if A1 is positive? In other words: B1 equals A1 if A1>0 otherwise = 0 B2 equals A1 if A1<0 otherwise = 0 Thank you

Table 1; Cell A1 0.352941176 Cell A2 0.125 Cell A3 -8 Table 2 B1 -2.833333333 B2 -8 B3 0.125 Table 3 A1 to B1 = False A1 to B2 = False A1 to B3 = False A2 to B1 = False A2 to B2 = False A3 to B3 = True etc. Please give me the formula that will match Cells A2 with B3 and A3 with B2.

Hi all I am trying to return the first row in a range where the value is #VALUE!. I am currently using the following formula but it doesn't seem to be working... =MATCH(ERROR.TYPE(3),Indices!$Z:$Z,0). It works when I am searching for a text string, say.... =MATCH("TEST",Indices!$Z:$Z,0)...