Results 1 to 3 of 3

Vlookup based on the Dropmenu data for Sheet name

Threaded View

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

    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

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