Thanks you Max & Fred. It works in both the cases.

"Fred Smith" wrote:

What you are missing is the parameters which Search will accept. When you
enter a function into Excel, it will show you what parameters it will
accept. In the case of Search, there's three:
find_text, within_text, start-num

So you are asking Excel to find "Direct Fundings" within the string "direct
funding" starting at position aa122. This can't be done, so Excel returns an
error.

My guess is you want to find either "Direct Fundings" or "direct funding"
anywhere in AA122. If so, you only have to search for the latter, as it's a
subset of the former. So try:
IF(ISERROR(SEARCH("direct funding",AA122)),"","Direct Fundings")

Regards,
Fred


"Dinesh" wrote in message
...
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")

Thanks to correct it.

Dinesh