+ Reply to Thread
Results 1 to 2 of 2

Find match of comma-separated values in another table

  1. #1
    Registered User
    Join Date
    02-27-2021
    Location
    Italy
    MS-Off Ver
    O365
    Posts
    1

    Find match of comma-separated values in another table

    Hi

    I have in Excel two tables Tab1 and Tab2

    Image.png

    I would like to get the result of Table1.Result column by finding all values of Table1.ID in Table2.ID. How can I get this result without using VBA? I use Excel in O365

    Thanks

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,474

    Re: Find match of comma-separated values in another table

    Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.

+ 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. Replies: 4
    Last Post: 12-01-2020, 01:20 PM
  2. Creating multiple searchs of a table with comma separated values
    By remyc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-20-2020, 07:24 PM
  3. Match criteria in table and make combinated result with comma separated
    By 155mahe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-15-2020, 04:53 PM
  4. [SOLVED] INDEX MATCH comma separated values in one cell
    By Jay S. in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-02-2019, 12:20 AM
  5. Replies: 5
    Last Post: 02-18-2017, 11:21 AM
  6. Find the earliest date within comma-separated values
    By Niclal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2014, 10:08 AM
  7. [SOLVED] Macro to match values in cells separated by semicolon and comma
    By Ale84 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-21-2013, 11:00 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