Closed Thread
Results 1 to 6 of 6

How to VLOOKUP on Entered Sheet?

  1. #1
    Registered User
    Join Date
    05-29-2021
    Location
    Manila,Philippines
    MS-Off Ver
    365
    Posts
    4

    Question How to VLOOKUP on Entered Sheet?

    Hi Guys, I am having a trouble creating a VLOOKUP formula on my database. I have 4 Sheets (Region1, Region 2, Region 3, Region 4).
    Now I want to have 2 VlookUP to retrieve the data.
    For example:
    In B2, If I put Region 1 then it will VlookUP on the Region 1 Sheet the Similar Name I entered in B3. Then If I put Region 2, it will retrieve info from Region 2 Sheet.
    I tried adding IF Function but it says " Too much argument" Something like that. Thank you in advance.

    here is my sample WB:
    Attached Files Attached Files
    Last edited by senniex; 05-30-2021 at 04:54 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How to VLOOKUP on Entered Sheet?

    You need to use the INDIRECT function for this.

    Without a sample WB to test with, this is a guess...
    =VLOOKUP(R25,INDIRECT("'"&B2&"'!A2:H5"),5,0)
    where A2:H5 is the range you are using
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    05-29-2021
    Location
    Manila,Philippines
    MS-Off Ver
    365
    Posts
    4

    Re: How to VLOOKUP on Entered Sheet?

    Hi, Thanks for your answer however it error on me it says "!REF". I attached my workbook , can you try it there if its ok? thankss

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

    Re: How to VLOOKUP on Entered Sheet?

    Why have you posted in the VBA section?
    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.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    05-29-2021
    Location
    Manila,Philippines
    MS-Off Ver
    365
    Posts
    4

    Re: How to VLOOKUP on Entered Sheet?

    oh yeah sorry I just noticed now. How can I delete this post?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,324

    Re: How to VLOOKUP on Entered Sheet?

    You should NOT have started a new thread, but asked for this one to be moved. Please read th3 forum rules carefully.

    Thread closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 16
    Last Post: 04-20-2017, 12:18 PM
  2. Hide or Unhide Rows on one sheet based on value entered in cell on another sheet
    By wfsteadman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-20-2016, 07:30 PM
  3. Moving complete rows of data from one sheet to a new sheet when a date is entered
    By meadnl89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-28-2014, 11:39 AM
  4. Replies: 1
    Last Post: 10-02-2014, 09:24 PM
  5. [SOLVED] vlookup list in sheet2 and count from sheet how many times item is entered formula / vba
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-12-2014, 02:12 PM
  6. [SOLVED] VBA to Auto Populate the “AutoPopulate” sheet as data is being entered in EnterData sheet
    By bjnockle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-13-2014, 09:10 AM
  7. Move entire row of data from Sheet 1 to sheet 2 when completed date is entered.
    By jt7721 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-18-2013, 11:50 AM

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