Please help with this Formula

[mrsphxbabe]

Hi everyone. I am going out of my mind here, I got someone to help me with this formula, but for some reason when I paste it into my spreadsheet, its not doing what I expected. Some times it wont paste all of the formula, or it goes into a different cell them where I can trying to paste it, or it gives me a #N/A or # REF result, and if I get it to paste into the cell, and I drag it down, it just copies it instead of giving me the results.
I cant seem to figure out how to upload my spread sheet here, but this is the formula, can anyone tell me if you see a problem with it?

=IF(B2<>"",INDEX(Sheet2!$B$1:$B$2000,MATCH("**",IF(ISNUMBER(SEARCH(B2,Sheet2!$A$1:$A$2000,1)),"**",0),0),1),INDEX(Sheet2!$B$1:$B$2000,MATCH("**",IF(ISNUMBER(SEARCH(C2,Sheet2!$A$1:$A$2000,1)),"**",0),0),1)))

Thank you in advance!

 

[jtakw]

Hi,

Don't know what your formula is doing, as there's nothing to reference to, but based on your description, check the cell formatting of the cells you're applying the formula to, sounds like the cells are formatted "Text", change the cell formatting to "General", then re-enter the formulas, then it should work.