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

Book2.xlsx

fmvizcaino

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

2019-12-09 Using filter with contains function for multiple values with strings.yxmd