P

#### pierre

given :

C

5 tea

6 tree

7 oil

my search string is D5.... also i put my formula in E5 :

=MATCH(D5;$C$5:$C$7;0)

this mean that if i type the word "tree" in cell D5...the result will be =2

which means the second criteria

NOW MY GOAL IS TO FIND A FORMULA WIHICH INDICATES ME THE LOCATION OF

THE WORD "TREE".....PLZ HELP

PS: IF THE GIVEN WOULD BE :

C

5 tea

6 tree

7 tree

HOW TO DEAL HERE WITH THE PRECEDENT PROCEDURE AND WHAT FORMULAS TO USE ???