help me(indirect function error)

T

tom taol

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(INDIRECT("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(E7)))),$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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation help 5
Evaluate an Array Formula before inserting it in a cell 9
Using the INDIRECT function across multiple worksheets 0
Evalute Array Formula in VBA code 2
Vlookup and return sheet name also 2
Using SUM(INDIRECT()) 2
Indirect and matching formula isn't working 3
Combining two formulas 0

Top