# VLOOKUP to return multiple unique results in a single cell

1. ## 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. ## 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. ## 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.

4. ## 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.

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

#### 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