+ Reply to Thread
Results 1 to 3 of 3

Indirect formulas help

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    Millbrae, CA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Indirect formulas help

    I am trying to use the Indirect formula to be able to reference a different tab when I write in a particular tab.

    Here's the formula which works exactly as I intended however I have made it too complex for me to figure out how to insert the Indirect portions!

    =INDEX(Pegasys!$D$2:$F$4,(MATCH($B$6,Pegasys!$C$2:$C$4,0)),MATCH(C$6,Pegasys!$D$1:$F$1,0))

    I'm referencing a tab called "Pegasys." Let's assume I want to write "Pegasys" in cell A1. How do I insert the Indirect function while leaving my combination of the Index and Match functions alone?

    Thank you

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Indirect formulas help

    Hi, maybe

    =INDEX(INDIRECT(A1&"!$D$2:$F$4"),(MATCH($B$6,INDIRECT(A1&"!$C$2:$C$4"),0)),MATCH(C$6,INDIRECT(A1&"!$D$1:$F$1"),0))

    Pegasys must be written with no spaces ( "Pegasys ").

    Regards

  3. #3
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: Indirect formulas help

    Hi again, I did not read with attention your post : sorry.

    If the tab name contains spaces, before A1 and before "!" I should add singole quotation marks

    Please Login or Register  to view this content.

    If the tab is called "Pegasys." with no space at the end, there is no need of single quotation marks to wrap A1

    Please Login or Register  to view this content.


    Hope it helps.

    Regards
    Last edited by canapone; 02-16-2011 at 05:01 AM. Reason: Extra clarification, before anyone read the post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1