value error

[Micayla Bergen]

=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,"")
--
Regards,

Peo Sjoblom


"Micayla Bergen" <MicaylaBergen@discussions.microsoft.com> wrote in message
news:9B6D0DB9-A91E-4C25-AE95-1BB1518595C9@microsoft.com...
> =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???