I have a really strange error and cannot figure out why, the error onmly occurs in a half dozen cells.
I have the formula =IF(MATCH(I51,V51,0),"Match",""). it works fine for 85% of my rows, however on some I am getting this "Value not available error".
in this example the cells its being asked to match, do match both say $36.46. when I go through calculation steps, it shows that V51 value not available.... but i can see it, its there and correct I have tried copying the formulas form the working cells above and below it, no change, i have checked but cannot find any differences in either if the cells in question
Dies anyone have any ideas?
I am using Excel 2010
I have the formula =IF(MATCH(I51,V51,0),"Match",""). it works fine for 85% of my rows, however on some I am getting this "Value not available error".
in this example the cells its being asked to match, do match both say $36.46. when I go through calculation steps, it shows that V51 value not available.... but i can see it, its there and correct I have tried copying the formulas form the working cells above and below it, no change, i have checked but cannot find any differences in either if the cells in question
Dies anyone have any ideas?
I am using Excel 2010
