Hi
On searching for your query re Macros, I noticed that you also had a problem
with multiple IF statements. Apart from using Index, you can, by using
helper column, create if statements nesting as many as you like. the formula
is:
=IF(<Cond1,<Result1,<Cond2,<Res2......Cond&,Re s7,"NOT YET")))))))
In the next column, you insert the following formula:
=IF(<Previous Column<"NOT YET",<Previous Column,IF(Cond8,Res8 and so on.

"titoto" wrote:

I need a formula which would enable me to search for more than 7 words ( I
have at least 20 word) and when 1 of the word is found to display that word.
In any given cell will contain 1 of the words needed.

'IF', 'Countif' function allow no more than 7 words.Any idea
eg
A B
hdfjjkduo...PAUL...iuepoipwp search PAUL or MARC or so on- Result
= PAUL


hhjhwoujiowqu...MARC...ioo Result = MARC
so on so on