Thread: value error
View Single Post
  #1   Report Post  
Micayla Bergen
 
Posts: n/a
Default value error

=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???