Apr 23 2021
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.
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.
Apr 30 2021
That could be
=IF(COUNTIF(B:B,"*"&A1&"*"), "it exists", "can't find")