+ Reply to Thread
Results 1 to 5 of 5

excel dropdown population and fetching values from another sheet in same file

  1. #1
    Registered User
    Join Date
    04-08-2014
    Location
    Mumbai
    MS-Off Ver
    Excel 2009
    Posts
    5

    excel dropdown population and fetching values from another sheet in same file

    Hello Experts,

    I need 2 dropdowns in my excel sheet.
    First dropdown will have Yes and No values.


    The 2nd dropdown should be populated if the first dropdown is selected as Yes or else the 2nd dropdown should not be populated.

    The 2nd dropdown will have 4 values A,B,C and D.

    Now when 1st dropdown is selected with Yes this populates the 2nd dropdown with A,B,C or D values.
    Now when A,B,C,D is selected in the 2nd dropdown the value must be fetch from the 4 cells of A,B,C,D which are in another sheet in the same excel file into Year 1,Year 2,Year 3. If No value is selected in the first dropdown then the 2nd dropdown should be disabled and Year 1,Year 2,Year 3 columns should be 0

    Untitled.png

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: excel dropdown population and fetching values from another sheet in same file

    Hi,

    Can you clarify please.

    Are the values in the 2nd drop down literally the characters "A", "B", "C" or "D"

    What do you mean by the value must be fetched from 4 cells A,B,C,D.

    If you could mock up a simple workbook that contains the selections and the results with notes explaining how you get the results that would help considerably.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-08-2014
    Location
    Mumbai
    MS-Off Ver
    Excel 2009
    Posts
    5

    Re: excel dropdown population and fetching values from another sheet in same file

    Hi,
    Thanks for the response.
    Yes - The characters in the 2nd dropdown are the values A,B,C,D


    Please see the attached excel file .
    sample.xls.xlsx

  4. #4
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: excel dropdown population and fetching values from another sheet in same file

    Hi,

    I'm still not sure what you mean by Year 1 2 & 3.

    This formula in C3 on sheet 2 will return the appropriate value from B15:E15 on sheet 1, but I don't understand when you would want row 16 to be used.

    Formula: copy to clipboard
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-08-2014
    Location
    Mumbai
    MS-Off Ver
    Excel 2009
    Posts
    5

    Re: excel dropdown population and fetching values from another sheet in same file

    Thanks Richard,This is exactly what I was looking for,
    row 16 is a redundant row which is not being used.
    Just one more question - How can I disbable the 2nd dropdown list when No is selected for the 1st dropdown?

    Thanks alot for your help!

+ 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. Copy / Paste Values Only one sheet into another file from a multi sheet excel file
    By srisri201012 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2013, 12:56 PM
  2. Problem Populating Excel File With Values From Sharepoint DropDown
    By MrIceGuy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2013, 09:32 AM
  3. Replies: 0
    Last Post: 07-10-2012, 08:37 AM
  4. Dropdown population (nested if functions)
    By kryt0n in forum Excel General
    Replies: 2
    Last Post: 06-17-2010, 08:12 AM
  5. Excel Worksheet not Fetching values
    By vinidimple in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-16-2006, 03:13 AM

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