Forum Discussion

Copper Contributor

Apr 23, 2021

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 fou...

SergeiBaklan

Diamond Contributor

Apr 30, 2021

MOKINAMORENO

That could be

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