Find and Replace tool

Question

Hello everybody,

I have the following columns in two separate files:

File 1

File 2

Is it possibile to search string of File 1 in File 2 and have,as output column, all code of of File 2 that CONTAIN the string in File 1? Is it possible to make it through Find and Replace tool? Is it any other way?

Thank you very much in advance.

Kind regards,

Alessandra

afv2688 · Answer

Hello @A121093 ,

I did some changes to the code. Let me know if it works now better for you.

Regards

Replace_values.yxmd

A121093 · Answer

Hello Emil_Kos,

I added a column in File 2, Code 1, where values are equal to RIGHT(Code;11) and the result is the one in the image below.

Please find below the vlookup setting.

This is the vlookup result, but I need also account S_ACD0*

Maybe I'm doing something wrong?

Kind regards

Emil_Kos · Answer

Hi @A121093,

In the find and replace tool there is a function to search for any part of the string:

Your final goal is to add a second column from file 2.

Can you direct me why this isn't working for you?

Find and Replace (1).yxmd