COLLECT contains ?
Hello, I have 2 sheets. In sheet 1 I have column 1A where each cell contains multiple alphanumeric codes separated by a semicolon
(column multiple codes). In sheet 2 I have column 2A where each cell contains one alphanumeric code (column single code) and column 2B where each cell contains the code description (column code description).
I am looking for a formula to be put in sheet 1 that collects all the descriptions from column 2B if one of the alphanumeric codes in the cell in column 1A is present in column 2A. Any idea on how to do this?
Help Article Resources
Check out the Formula Handbook template!