=IF(FIND("TRANSFER",B4),D4,"")If the culumn B4 contains the word TRANFER, this will return the value of column D4
- But the problem is that if the word is not present, then the function FIND returns an error #value!
- The solution is to use the ISNUMBER() function, to avoid that error. The function becomes something of the sort:
=IF(ISNUMBER(FIND("TRANSFER",B4)),D4,"")I found this solution on the OpenOffice wiki.