location
I assume by location you mean the cell address:
="C"&INDEX(ROW(C5:C7),MATCH(D5,C5:C7,0))
As for the precedence, the formula will *always* find the first instance. Do
you want *all* the locations listed?
--
Biff
Microsoft Excel MVP
"pierre" wrote in message
...
hi ...plz help
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 ???
|