Nested formula help please

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
 

jsuarezg

New member
Joined
Sep 21, 2013
Messages
24
Reaction score
0
Points
0
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))),"")


 
Top