+ Reply to Thread
Results 1 to 5 of 5

Indirect Function with Vlookup vs. Index/Match

  1. #1
    Registered User
    Join Date
    06-30-2012
    Location
    San Jose
    MS-Off Ver
    Excel 2010
    Posts
    3

    Indirect Function with Vlookup vs. Index/Match

    Hi,

    I've been playing around with the Indirect Function and how it can be used for workbooks with multiple sheets. I've been successful using it for Vlookups but can't get it to work for Index and Match functions.

    Here is the Vlookup function that works:

    =VLOOKUP(A9204,INDIRECT(D9204&"!A:o"),15,FALSE)

    Here is the Index/Match Function I am trying which does not work:

    =(INDEX(INDIRECT(D9204&"!A:o"),MATCH(A9204,INDIRECT(D9204&"!A:o"),FALSE),15))

    Any help on what I'm doing wrong with the Index/Mathc version would be appreciated.

    Thanks,

    Jayule

  2. #2
    Registered User
    Join Date
    06-30-2012
    Location
    San Jose
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Indirect Function with Vlookup vs. Index/Match

    Nevermind, I figured it out. The second indirect function should be a:a as opposed to a:o.

  3. #3
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Indirect Function with Vlookup vs. Index/Match

    Glad it all worked out. Can you please mark the thread as solved.

    Good luck.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.

  4. #4
    Registered User
    Join Date
    06-30-2012
    Location
    San Jose
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Indirect Function with Vlookup vs. Index/Match

    How do I do that?

  5. #5
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Indirect Function with Vlookup vs. Index/Match

    Try this...

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    HTH
    Regards, Jeff

+ 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