FIND AND REPLACE

[Lean_Sawko]

Hi everyone,

I need your help, I have 2 different files with different rows and columns.

I create a new column to identify an ID. if this ID match in second file I want it to bring me the ID2, It's pretty similar to the =VLOOKUP(A1:A2, 2, 0) How you do this in the simplest possible way? 

Thanks,

 Leandro

[Qiu · Accepted solution]

@Lean_Sawko 
I can think of is Find and Replace.

Try to explore the sample first.

With some sample data, I can explain it better.