Closed Thread
Results 1 to 5 of 5

VLOOKUP reference

Hybrid View

  1. #1
    Registered User
    Join Date
    07-11-2017
    Location
    New York, USA
    MS-Off Ver
    2016
    Posts
    4

    VLOOKUP reference

    I am using the vlookup to retrieve values from a 2nd Workbook/Worksheet (I will call this the Reference workbook)

    The reference workbook has multiple sheets.

    My primary workbook has a column that has the corresponding values for the sheet to be used for that lookup.

    So, my VLOOKUP command is: =VLOOKUP(H2,[REFWORKBOOK]WORKSHEET'$A$1:$D$2000,4,FALSE

    I would like to substitute "WORKSHEET" in this formula with the value of Column E. I have tried the INDIRECT function, but get an error:
    =VLOOKUP(H2,[REFWORKBOOK]INDIRECT(E2)'$A$1:$D$2000,4,FALSE

    Any way I can do this?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,762

    Re: VLOOKUP reference

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional. Thanks!

    No help to be offered, please, until the OP complies with this request.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    07-11-2017
    Location
    New York, USA
    MS-Off Ver
    2016
    Posts
    4

    Re: VLOOKUP reference

    Thanks Much

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,762

    Re: VLOOKUP reference

    Try this:

    Using VLOOKUP with an External Workbook and the INDIRECT Function

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,762

    Re: VLOOKUP reference

    You were asked to change the title of this thread, not start a new one.

    Thread closed. Please continue here: https://www.excelforum.com/excel-for...-function.html

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VLOOKUP with Reference
    By Settler7 in forum Excel General
    Replies: 4
    Last Post: 11-01-2016, 12:15 PM
  2. Userform to return vlookup then reference vlookup text
    By BG1983 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-17-2016, 02:09 PM
  3. vlookup reference
    By jm1234 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-04-2007, 05:31 PM
  4. Making VLookup Absolute reference and deleting worksheet reference question
    By crowdx42 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2006, 12:45 PM
  5. [SOLVED] VLOOKUP Reference Help
    By Max in forum Excel General
    Replies: 4
    Last Post: 12-19-2005, 03:35 PM
  6. Replies: 10
    Last Post: 04-29-2005, 05:06 PM

Tags for this Thread

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