Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Does anyone know if this formula exceeds the maximum number of nested
functions? =HYPERLINK(CONCATENATE(D102,(SUBSTITUTE(EL3," ","+")),D104,(SUBSTITUTE(LEFT(EL4,(LEN(EL4)-4))," ","+")),D106,"VA",D108,(SUBSTITUTE(VLOOKUP(EN11,Sh eet1!H2:L50,5)," ","+")),D110,(SUBSTITUTE(VLOOKUP(EN11,Sheet1!H2:L5 0,2)," ","+")),D112,SUBSTITUTE(LEFT(VLOOKUP(EN11,Sheet1!H 2:L50,5,LEN(VLOOKUP(EN11,Sheet1!H2:L50,5)-4))," ","+"),D114& "VA"& D116),"Map") This one seems to work without error, but I have a need to add an extra VLOOKUP function to make the result correct. =HYPERLINK(CONCATENATE(D102,(SUBSTITUTE(EL3," ","+")),D104,(SUBSTITUTE(LEFT(EL4,(LEN(EL4)-4))," ","+")),D106,"VA",D108,(SUBSTITUTE(VLOOKUP(EN11,Sh eet1!H2:L50,5)," ","+")),D110,(SUBSTITUTE(VLOOKUP(EN11,Sheet1!H2:L5 0,2)," ","+")),D112,SUBSTITUTE(LEFT(VLOOKUP(EN11,Sheet1!H 2:L50,5,LEN(EL4)-4))," ","+"),D114& "VA"& D116),"Map") If there's a better (cleaner) way to do this, I'm open to ideas. Thanks, Paul |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula Question | Excel Discussion (Misc queries) | |||
Nested if question | Excel Discussion (Misc queries) | |||
formula question | Excel Discussion (Misc queries) | |||
Formula Question | Excel Discussion (Misc queries) | |||
Formula question... | Excel Discussion (Misc queries) |