One alternative in this instance:
=IF(COUNTIF(AA122,"*direct funding*"),"Direct Fundings","")
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik
---
"Dinesh" wrote:
The following formula do not work to capture the either of the test string. I
guess I am missing something here.

IF(ISERROR(SEARCH("Direct Fundings","direct funding",AA122)),"","Direct
Fundings")