I am using the IF function to look for a particular word and copy it to
another cell.

H2: =IF(A2="Example Text",A2, "")

The problem is that if the word "Example Text" is not found it deletes
anything in the target cell or puts FALSE into the target cell (if I
take out the "").

How can I preserve the text in the target cell if "Example Text" is not
there?

any help would be greatly appreciated!!