there are the following data in a2:a6 cells.
cole
march
monda
stud
midx

and there is the following data in e7 cell.
studev

=INDIRECT("a"&MAX(IF(ISNA(MATCH(MID(E7,1,row(INDIR ECT("1:"&LEN(E7)))),$A
$2:$A$6,0)),0,MATCH(MID(E7,1,ROW(INDIRECT("1:"&LEN (E7)))),$A$2:$A$6,0)))
+1)

the result len(e7) is selected of error..
but,
MAX(IF(ISNA(MATCH(MID(E7,1,row(INDIRECT("1:"&LEN(E 7)))),$A$2:$A$6,0)),0,
MATCH(MID(E7,1,ROW(INDIRECT("1:"&LEN(E7)))),$A$2:$ A$6,0)))+1
the result normality, return 5.

i want to get value of a5 cell.





*** Sent via Developersdex http://www.developersdex.com ***