+ Reply to Thread
Results 1 to 3 of 3

retrieve data related to selection in dro down list.

  1. #1
    Registered User
    Join Date
    10-14-2014
    Location
    Ontario, Canada
    MS-Off Ver
    2007
    Posts
    4

    retrieve data related to selection in dro down list.

    Hi everyone,

    I currently have an issue and could use your help!

    I would like to use a drop down list to show only the data related to the item choosen. I have attached an sample of the data.

    I currently have all the data on one worksheet but I am willing to move it onto a seperate worksheet.

    I would also need to be able to add claims and possibly tasks in the future.

    Any advice would be greatly appreciated.

    If I am not clear please ask!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-03-2009
    Location
    Florence, Italy
    MS-Off Ver
    Excel 2019
    Posts
    1,796

    Re: retrieve data related to selection in dro down list.

    Hi,

    not sure to have understood - my bad - it looks you need automatic filter in A1 to show only related data.

    INDEX formula can extract from your data, only some rows under condition you choose

    Not sure it's of some help
    -----------------------------------------------------

    At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.

    Please, mark your thread [SOLVED] if you received your answer.

  3. #3
    Registered User
    Join Date
    10-14-2014
    Location
    Ontario, Canada
    MS-Off Ver
    2007
    Posts
    4

    Re: retrieve data related to selection in dro down list.

    Sorry for the confusion,

    I need to be able to select a 'claim' from a drop down list and have the corresponding tasks $ values to show up under their original 'tasks'.

    I am not familar with INDEX formula.. I will do alittle research Thanks!

    *still referencing original "example test" excel document

+ 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. VBA code to populate data related to drop down list
    By ExcelGyan in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-04-2011, 03:32 AM
  2. retrieve a specific row of data after criteria selection?
    By paulinexiaoli in forum Excel General
    Replies: 4
    Last Post: 06-28-2010, 08:41 AM
  3. retrieve data from a list of corresponding values
    By ttroake87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2009, 08:32 AM
  4. Retrieve unique data to list
    By Jeaz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2006, 12:20 AM
  5. Have a drop-down list retrieve data
    By mbwooten in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 09-08-2006, 03:12 PM

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