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?
Bookmarks