Hi, can anybody clarify what's wrong with this formula:
=IF(ISNUMBER(SEARCH(A1;D:D));E1;"no hit")

The idea is: test if the value of cell A1 is present in column D.
If so, fill the cell with the content of cell E1
Otherwise with "no hit".

The formula produces 'No hit', so I guess the IF test results in FALSE.

Thanks for your help!