Consolidating columns plus lookup and return multiple values?

retboell

New Member
Joined
Dec 17, 2018
Messages
3
Hi all,

I'm looking to find a solution for joining (sorting and removing duplicates) multiple columns in one cell and then lookup all values in a separate table and return potential values in another cell. It would look something like this:

Column1Column2Column3Column4ConsolidatedLookup values
Apple AppleA
Banana,Apple Apple,BananaA,C
OrangeOrangeOrangeB
Banana Orange Banana,OrangeB,C
Apple BananaApple,BananaA,C

<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>

Note that Columns can contain multiple values.

The lookup table in this example would be:
FruitLetter
AppleA
OrangeB
BananaC

<colgroup><col span="2"></colgroup><tbody>
</tbody>

I have found partial solutions out there, but often combining these slows down my spreadsheet.

Thanks!
 

Forum statistics

Threads
1,078,344
Messages
5,339,663
Members
399,318
Latest member
kryten68

Some videos you may like

This Week's Hot Topics

Top