Forum Discussion
MOKINAMORENO
Apr 23, 2021Copper Contributor
VLOOUKUP - CONTAINING PART OF DATA
Good morning,
I'm trying to find a way to retrieve if part of text is contained in other column, and if so, then retrieving that info in my cell.
Example:
Column A: 00102MEA5411 (data to be found in column B)
Columna B: JFK20200102MEA5411
No all data have the same structure.
Therefore I'd need to find if that word in column A is contained in any cell of column B.
Many thanks
1 Reply
- SergeiBaklanDiamond Contributor