+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP to return multiple unique results in a single cell

  1. #1
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    VLOOKUP to return multiple unique results in a single cell

    I've got Table 1 with tracking numbers. I've got Table 2 with tracking numbers and invoice numbers. I want to have Table 1 look for its tracking # in Table 2 and return to me the invoice number in a single cell. (Sometimes there will be a single tracking number that appears on 3 different invoices and I want all invoice numbers to appear in the same cell.) I've found a formula that will pull all results in a single cell. BUT . . . it's returning every single time that tracking number appears on that invoice which could be upwards of 15 times. I want a formula that will return multiple UNIQUE results into one cell. Any ideas?

  2. #2
    Registered User
    Join Date
    12-06-2019
    Location
    Utah
    MS-Off Ver
    Office 365
    Posts
    37

    Re: VLOOKUP to return multiple unique results in a single cell

    This is the formula I'm currently using: =TEXTJOIN(", ",TRUE,IF(G:G=E1,I:I,""))

    How do I tweak that to return just unique values in a single cell and not all values?

    (This formula is slightly altered from how it is actually displayed in my spreadsheet. I keep getting an error here telling me I can't post links, images or videos since I'm a relatively new user. I don't know what it is about that formula that is triggering the error.)

  3. #3
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,535

    Re: VLOOKUP to return multiple unique results in a single cell

    It may help someone to come up with a solution if you upload a sample as described in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    43,986

    Re: VLOOKUP to return multiple unique results in a single cell

    It is correct that you can NOT upload links until you'v emade about 10 posts (an anti-spam measure that doesn't really work!!). But you can attach your sheet here.

    But... (another "feature" of this site...), not in the normal way. Because...

    Unfortunately the attachment icon doesn't work at the moment. So,... instead click on Go Advanced (below the Edit Window) while composing your reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

+ 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: 5
    Last Post: 05-27-2019, 03:46 PM
  2. VBA VLookUp 1 condition return in 1 cell multiple results.
    By SistemasCalexico in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2017, 02:49 AM
  3. [SOLVED] vLookup multiple values separated by ";" in single cell / return result in single cell
    By Tunesmith in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2015, 12:02 PM
  4. Replies: 4
    Last Post: 09-04-2014, 01:24 PM
  5. VLOOKUP to Search Cell with Multiple Entries and Return a Single Value
    By TheRob in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-07-2014, 08:54 AM
  6. [SOLVED] Vlookup & return all unique values to a single cell
    By PY_ in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-24-2013, 02:42 AM
  7. [SOLVED] lookup multiple values of a single cell and return sum of results
    By Zeppelin17 in forum Excel General
    Replies: 7
    Last Post: 08-10-2011, 07:09 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