Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
help me(indirect function error)
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#Ref! error using INDIRECT for file name | Excel Discussion (Misc queries) | |||
Error when using Indirect | Excel Worksheet Functions | |||
Error using Excel add-in with INDIRECT.EXT function | Excel Discussion (Misc queries) | |||
Error Embedding Row() within Indirect() | Excel Worksheet Functions | |||
INDIRECT function error | Excel Discussion (Misc queries) |