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:
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
Note that Columns can contain multiple values.
The lookup table in this example would be:
<colgroup><col span="2"></colgroup><tbody>
</tbody>
I have found partial solutions out there, but often combining these slows down my spreadsheet.
Thanks!
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:
Column1 | Column2 | Column3 | Column4 | Consolidated | Lookup values |
Apple | Apple | A | |||
Banana,Apple | Apple,Banana | A,C | |||
Orange | Orange | Orange | B | ||
Banana | Orange | Banana,Orange | B,C | ||
Apple | Banana | Apple,Banana | A,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:
Fruit | Letter |
Apple | A |
Orange | B |
Banana | C |
<colgroup><col span="2"></colgroup><tbody>
</tbody>
I have found partial solutions out there, but often combining these slows down my spreadsheet.
Thanks!