VLOOUKUP - CONTAINING PART OF DATA

%3CLINGO-SUB%20id%3D%22lingo-sub-2282382%22%20slang%3D%22es-ES%22%3EVLOOUKUP%20-%20CONTAINING%20PART%20OF%20DATA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282382%22%20slang%3D%22es-ES%22%3E%3CP%3EGood%20morning%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20find%20a%20way%20to%20retrieve%20if%20part%20of%20text%20is%20contained%20in%20other%20column%2C%20and%20if%20so%2C%20then%20retrieving%20that%20info%20in%20my%20cell.%3C%2FP%3E%3CP%3EExample%3A%3C%2FP%3E%3CP%3EColumn%20A%3A%20%3CSTRONG%3E00102MEA5411%3C%2FSTRONG%3E%20(data%20to%20be%20found%20in%20column%20B)%3C%2FP%3E%3CP%3EColumn%20B%3A%20JFK202%3CSTRONG%3E00102MEA5411%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%20all%20data%20have%20the%20same%20structure.%3C%2FP%3E%3CP%3ETherefore%20I'd%20need%20to%20find%20if%20that%20word%20in%20column%20A%20is%20contained%20in%20any%20cell%20of%20column%20B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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")