+ Reply to Thread
Results 1 to 13 of 13

Pull multiple data (Table) based on specific value

  1. 05-08-2023, 06:33 AM #1
    Wilkins
    Wilkins is offline
    Registered User
    Join Date
    05-08-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    4

    Pull multiple data (Table) based on specific value

    Hi everyone, hope you can help me with the following issue:

    On the worksheet ("Overview") from below, I would like to display, let's say in "B16", 2 columns (Date & Comments) from a table placed in the "DB_Feedback" worksheet.
    01.png

    "DB_Feedback".
    02.png

    I have only been successful pulling out one row per customer, but with multiples values, as for example for the one that is selected in the dropdown list (Nowel), which has data in "A2", "A5", "A7", "A8", "A9" & "A10", I don't know how to properly write the formula to display all the existing rows (C for Date, and D for Comments) for that specific value.

    Appreciate any kind of help, thank you!
    Attached Files Attached Files
    Last edited by Wilkins; 05-08-2023 at 06:47 AM.
    Reply With QuoteRegister To Reply
  2. 05-08-2023, 06:40 AM #2
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file and a mocked up solution.
    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

    Reply With QuoteRegister To Reply
  3. 05-08-2023, 06:45 AM #3
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Maybe
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  4. 05-08-2023, 09:26 AM #4
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,524

    Re: Pull multiple data (Table) based on specific value

    Moved to the VBA section at the OP's request.

    @Wlkins - please acknowledge the help that you have been kindly offered here.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  5. 05-08-2023, 09:33 AM #5
    Wilkins
    Wilkins is offline
    Registered User
    Join Date
    05-08-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    4

    Re: Pull multiple data (Table) based on specific value

    Hey TMS,

    I applied those changes but did not work, appreciate your help anyway.
    Reply With QuoteRegister To Reply
  6. 05-08-2023, 09:35 AM #6
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,524

    Re: Pull multiple data (Table) based on specific value

    Define "did not work". There may be a way to tweak the formula to work for you. It would be easier if you provided a workbook showing the issue, though.
    Reply With QuoteRegister To Reply
  7. 05-08-2023, 09:40 AM #7
    Wilkins
    Wilkins is offline
    Registered User
    Join Date
    05-08-2023
    Location
    Spain
    MS-Off Ver
    365
    Posts
    4

    Re: Pull multiple data (Table) based on specific value

    I think the file is attached and available for everyone. At least from my side it looks like it, let me know if it's not as I just signed in today and I might be wrong.
    Last edited by AliGW; 05-08-2023 at 09:43 AM. Reason: Please do NOT quote unnecessarily!
    Reply With QuoteRegister To Reply
  8. 05-08-2023, 09:42 AM #8
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,524

    Re: Pull multiple data (Table) based on specific value

    IT is, however that's not the version where you have tried to implement Trevor's suggestion - that's the version we need to see.
    Reply With QuoteRegister To Reply
  9. 05-08-2023, 10:00 AM #9
    AliGW
    AliGW is online now
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2406 (Windows 11 23H2 64-bit)
    Posts
    81,524

    Re: Pull multiple data (Table) based on specific value

    OK - still waiting, so I've done it myself. Here is your workbook with Trevor's formula applied. In what way is this NOT what you are wanting? Explain what you think is wrong with it.

    AliGW on MS365 Beta Channel (Windows 11) 64 bit

    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    15
    Date
    Comments
    16
    15/04/2023
    		 kjkdjfkd
    17
    09/04/2023
    		 dfhdhdhthjyfjhfy
    18
    01/03/2023
    		 fjgfjfgj
    19
    06/02/2023
    		 gfjfjfgjgjgfj
    20
    05/02/2023
    		 fgjfgjjjfjfgjg
    21
    03/02/2023
    		 gfjfjfjgjjgfgjfgjfgj
    Sheet: Overview
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  10. 05-08-2023, 10:46 AM #10
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Thanks Ali. Looks OK to me. It returns six pairs of dates and comments for the name selected.
    Reply With QuoteRegister To Reply
  11. 05-08-2023, 10:48 AM #11
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Not sure why VBA is required. If you asked me for a VBA solution, I'd drop that formula in and convert to values.
    Reply With QuoteRegister To Reply
  12. 05-08-2023, 04:34 PM #12
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Is this resolved now? If not, please clarify any outstanding issues.
    Reply With QuoteRegister To Reply
  13. 05-09-2023, 07:28 PM #13
    TMS
    TMS is offline
    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,697

    Re: Pull multiple data (Table) based on specific value

    Again, is this resolved now?
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to Pull Through Specific Data from one Table / Tab to another
    By splottoman in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2020, 02:56 AM
  2. I need to pull specific data based on multiple criteria
    By rseckler in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-25-2020, 02:28 PM
  3. [SOLVED] Need to pull Data out of Pivot Table into specific cells
    By Chris McGlothen in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-30-2016, 11:13 AM
  4. [SOLVED] Pull data from a table based on multiple criteria - old formula trying to use AND
    By tweaver in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2016, 04:37 PM
  5. Enter data into specific row in data table based on multiple criteria
    By bberger1985 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-05-2013, 11:04 AM
  6. Pull random data based on specific criteria
    By Jrsmith1 in forum Excel General
    Replies: 1
    Last Post: 09-17-2012, 11:09 PM
  7. Help searching through multiple tables to pull data into a specific table
    By Cyali in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-19-2012, 02:36 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1