Using filter with contains function for multiple values with strings

[maksu]

Hi,

I need help for one expression.

I have a string source data and I need vlookup for searching a string from external excel file, but source data and external data meets with contains by using filter tool.

For example,

I want to vlookup an external string value from source, and want to see needed value. But, you can see in the attachment, external string value contains in source. 

I need an expression for approximately 3000 source.

Thanks a lot.

Mert

[fmvizcaino · Accepted solution]

Hi @maksu ,

I used a find replace to bring the external value to your lookup table and from there, I can use a join to find the specific value.

Take a look at the attached example and let me know if that works for you.

Best,

Fernando Vizcaino

[DiganP]

@maksu You can use the formula tool with a conditional function to compare them. Does this work for you?