Thread: LOOK UP function

This should be relatively easy but I haven't done this in a while. Can someone please help?


If a cell in the left column has a word 'satisfaction' within the sentence, how do I add the word 'satisfaction' in a cell in a column next to it?

Thank you
Julia

Numerous routes... one might be:

B1: =REPT("satisfaction",ISNUMBER(SEARCH("satisfaction",A1)))

use FIND instead of SEARCH if you wish the above be case sensitive (eg Satisfaction <> satisfaction)

Something like:

=IF(ISNUMBER(SEARCH("satisfaction",A1)),"satistaction","")

Try this:

=IF(ISERROR(FIND("satisfaction";A1)),"","satisfaction")