Finding 2 references

[JakeMann]

Hi All,

I am using the following formula to find the word 'Purfleet' from a strong of data.

I'd like to also find the word 'scrap' as well. Is that possible with the formula I'm using?

=IF(ISNUMBER(SEARCH("*Purfleet*",G481)),"Purfleet","")

[Gatti]

=IF(ISNUMBER(SEARCH("*Purfleet*",G481)),"Purfleet",IF(ISNUMBER(SEARCH("*scrap*",G481)),"scrap",""))

[Pete_UK]

You could do it like this:

=TRIM(IF(ISNUMBER(SEARCH("*Purfleet*",G481)),"Purfleet","") & " " & IF(ISNUMBER(SEARCH("*scrap*",G481)),"Scrap",""))

so you will get:

Purfleet
Scrap
Purfleet Scrap

or a blank, depending on whether the words are there or not.

Hope this helps.

Pete

[JakeMann]

Perfect. Thanks guys. Both options do the trick.