| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| ERROR | Excel Discussion (Misc queries) | |||
| #REF error | Excel Worksheet Functions | |||
Threaded Mode
