Results 1 to 4 of 4

Thread: Nested formula help please

  1. #1

    Nested formula help please



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Seeker ExcelTactics's Avatar
    Join Date
    Sep 2013
    Location
    Seattle, WA, USA
    Posts
    9
    Articles
    0
    Like this?

    =IFERROR(INDEX(INDIRECT("B"&$E$2+0&LEFT($F$2)&42),ROWS($C$2:$C2)),IFERROR(INDEX(INDIRECT("_C"&$E$2),ROWS($C$2:$C2)),""))
    ---
    Like what you just read? Learn how to master Excel with new tips and tutorials each week at ExcelTactics.com.

  3. #3
    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))),"")


    Microsoft Excel Massive Open Online Course.
    Learn all about Microsoft excel in this Online course, with video tutorials, examples of applications and a complete functions and buttons explanation.
    Be part of our community and enjoy learning Excel.

  4. #4
    Thanks Guys ExcelTatctics worked a treat.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •