Nested formula help please

P

pleased2help

New member
Joined
Jun 27, 2013
Messages
28
Reaction score
0
Points
0
Can I nest these functions together
1).. =IFERROR(INDEX(INDIRECT("B"&$E$2+0&LEFT($F$2)&42),ROWS($C$2:$C2)),"")
And
2)… =IFERROR(INDEX(INDIRECT("_C"&$E$2),ROWS($C$2:$C2)),"")
Instead of having two formulas can anybody help me to combine these …I’m stumped
Many thanks in advance
 
Hello you can do it like that too:

=IFERROR(OR(-- First INDEX function --,-- Second INDEX function --),"")

 =IFERROR(OR(INDEX(INDIRECT("B"&$E$2+0&LEFT($F$2)&42),ROWS($C$2:$C2)),INDEX(INDIRECT("_C"&$E$2),ROWS($C$2:$C2))),"")


 
You must log in or register to reply here.
Back
Top