+ Reply to Thread
Results 1 to 3 of 3

Vlookup based on the Dropmenu data for Sheet name

  1. #1
    Registered User
    Join Date
    07-08-2012
    Location
    chennai
    MS-Off Ver
    Excel 2019
    Posts
    54

    Vlookup based on the Dropmenu data for Sheet name

    Hi,

    I am attaching sheet which contains the data in the first sheet and month wise data in the second , third and fourth sheet.

    Now if i put the vlookup based on drop down menu E2 automatically month data will fetch.

    For example if the drop menu is Jan'22 Month then the data from the sheet Jan'22 will shown in the vlookup. If i change the drop menu to Feb'22 then the data from the Feb'22 will shown in the first sheet

    I am attaching the sheet Kindly help in resolving where to change the Cell name in the formula

    Thanks
    Sham
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,370

    Re: Vlookup based on the Dropmenu data for Sheet name

    Try

    =VLOOKUP($B5,INDIRECT("'" &$E$2& "'!A:F"),COLUMN(B1),0)

    Tabs named changed to Jan_22, Feb_22, Mar_22
    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,370

    Re: Vlookup based on the Dropmenu data for Sheet name

    Add ERROR condition

    =IFERROR(VLOOKUP($B5,INDIRECT("'" &$E$2& "'!A:F"),COLUMN(B1),0),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-26-2020, 09:12 AM
  2. Replies: 6
    Last Post: 04-30-2019, 04:13 AM
  3. Replies: 7
    Last Post: 07-21-2014, 12:10 AM
  4. Replies: 2
    Last Post: 04-04-2013, 10:32 AM
  5. Replies: 7
    Last Post: 12-16-2012, 04:24 PM
  6. Building a table automatically based on data from another sheet (vlookup?)
    By HyperG in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-20-2012, 11:34 PM
  7. As user fills out data sheet, then fill out a results sheet based on data sheet entry
    By clemsoncooz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-13-2012, 03:57 PM

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