VLOOUKUP - CONTAINING PART OF DATA

Copper Contributor

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

@MOKINAMORENO 

That could be

=IF(COUNTIF(B:B,"*"&A1&"*"), "it exists", "can't find")