Search Formula

  • Thread starter Thread starter Dinesh
  • Start date Start date
D

Dinesh

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
 
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
 
Back
Top