+ Reply to Thread
Results 1 to 4 of 4

Autopopulate data depending on the selection from the dropdown list

  1. #1
    Forum Contributor
    Join Date
    06-23-2012
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    127

    Autopopulate data depending on the selection from the dropdown list

    Hi Guys

    Need some assistance to populate MTD data linked to the other spreadsheet file (monthly data) to the table on the left, depending on the month selected month from the dropdown list.

    Attached files for reference.

    Many thanks in advance for assistance.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-18-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Autopopulate data depending on the selection from the dropdown list

    lookup should work, but I am trying to test it and its not working, I am looking into why.

  3. #3
    Registered User
    Join Date
    01-18-2012
    Location
    Texas
    MS-Off Ver
    Excel 2010
    Posts
    28

    Re: Autopopulate data depending on the selection from the dropdown list

    ok you can use nested IF statments. Lookup is easier but it is not reading the month titles correctly. so if b1 is your dropdown box and the month name is in monthlydatab1 then you would use IF($b$1=monthlydata!$b$1,monthlydata!b2,if($b$1=monthlydata!$c$1,monthlydata!c2 etc.

    if you can get lookup to work then let me know. if not i hope this helps.

  4. #4
    Registered User
    Join Date
    08-30-2012
    Location
    UAE
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Autopopulate data depending on the selection from the dropdown list

    Yes and you can also use sumif function for your requirement, herewith I attached the sample sheet
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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