+ Reply to Thread
Results 1 to 5 of 5

Dynamic Lookup Lists

  1. #1
    Registered User
    Join Date
    06-19-2023
    Location
    Seattle
    MS-Off Ver
    365
    Posts
    6

    Dynamic Lookup Lists

    Hello!

    I'm trying to make a dynamic list that pulls several results based on 1 criteria from on sheet to another.

    On the attached workbook, I'm trying to get Sheet 3 to pull the corresponding columns from Sheet 2 based on the identifier in C2 on Sheet 3

    Any help is much appreciated!
    Attached Files Attached Files

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Dynamic Lookup Lists

    This:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Dynamic Lookup Lists

    A bit more robust:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    06-19-2023
    Location
    Seattle
    MS-Off Ver
    365
    Posts
    6

    Re: Dynamic Lookup Lists

    Thank You.

    This is great!

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Dynamic Lookup Lists

    You're welcome.



    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

+ 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. [SOLVED] Dynamic Lists
    By mezza89 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 02-03-2024, 04:02 PM
  2. [SOLVED] Dynamic Lists
    By rabbit_post in forum Excel General
    Replies: 4
    Last Post: 03-23-2018, 04:18 AM
  3. [SOLVED] Help with Dynamic Validation Lists / Drop Downs / dynamic filters
    By rjnc in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-22-2016, 08:10 PM
  4. Dynamic Lists
    By russmeister in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-27-2015, 01:15 PM
  5. [SOLVED] Cell Lookup (Rate) based on Dependant Data Val using Dynamic Lists
    By LSN in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-02-2013, 08:43 AM
  6. Dynamic Lists
    By Zandra in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-04-2009, 09:47 PM
  7. [SOLVED] Dynamic Lists
    By Alex Mackenzie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2006, 02:45 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