Find a set of words or characters in a Cell using complex formula

Hi all,

I've got the following formula that I'm using. It basically brings in specific values from another page. Then blanks out the value within the cell if the IF statement is true.

Currently using,

=IF(S35="E","",IFERROR(INDEX(Sheet1!Y$4:AC$432,MATCH($A35,Sheet1!AC$4:AC$432,0),1),""))

Would like to incorporate Find / Search

=if(FIND("EUR",A1),"TRUE","FALSE")

Trying to do something like the following, but the following fails.

=IF(FIND("E",S35),"",IFERROR(INDEX(Sheet1!Y$4:AC$432,MATCH($A30,Sheet1!AC$4:AC$432,0),1),""))

NE hlp is appreciated.


Thanks

BDB

You need to add an ISNUMBER() check to see if the result of the FIND() is numeric or error...

e.g.

=IF(ISNUMBER(FIND("E",S35)),"",IFERROR(INDEX(Sheet1!Y$4:AC$432,MATCH($A35,Sheet1!AC$4:AC$432,0),1),""))

Note that FIND is case-sensitive.. if you don't want that use SEARCH() instead.