value error

[Guest]

=IF(OR(ISNUMBER(SEARCH("CMT",A4)),ISNUMBER(SEARCH("DIVS",A4))),(I4:J4),"")

i have 'cmt' in A4 and i want the value of cells I4&J4 but i get a value
error. not sure how or why, when i hit function it evaluates correctly, but
it says a value used in the formula is of the wrong data type
i dont know which one it is???

 

[Peo Sjoblom]

You have to put the formula in 2 cells horizontally and enter it with ctrl +
shift & enter
You cannot return a range in one cell, you could use

=IF(OR(ISNUMBER(SEARCH("CMT",A4)),ISNUMBER(SEARCH("DIVS",A4))),I4&J4,"")

or if you want a space between

=IF(OR(ISNUMBER(SEARCH("CMT",A4)),ISNUMBER(SEARCH("DIVS",A4))),I4&" "&J4,"")