+ 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
    14

    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
    14

    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 2010/2019
    Posts
    11,946

    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
    Sadly... in lockdown, but based in Ireland.
    MS-Off Ver
    µSoft Office 365. Learning Excel all over again!!
    Posts
    29,938

    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



+ 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