Multiple string VLOOKUP

Question

Hi,

I'm trying to do VLookup using Find Replace tool from two different excel files, but since i have to do multiple combinations of VLookups and the data may not match exactly I'm unable to arrive at the expected results. Please see the screenshot below where table1, table2 with desired output.

Note : This is just a sample data.

any suggestions appreciated...Thanks

FinnCharlton · Answer

@AKISHORE , I would approach the problem like this:

In the Join tool, we join the two datasets on Name, Established Country and Booked Country. This replicates the functionality of using a VLookup for all these fields. Hope this helps!

Vlookup.yxmd

AKISHORE · Answer

Thank you Shankar V for your response but i may have not explained it better. Below picture has one more record added in table 2(Red border) with the same name but with different Established Country, Booked Country and ID and i would like to get the 2nd row(Green Bordered) record ID in the output since the name, established country and booking country are same in the table 2 cells.

Really appreciate your help..

ShankerV · Answer

Hi @AKISHORE

Step 1: Input both datasets

Step 2:

Step 3:

(.+)(\s.+)

Step 4:

(.+)(\s.+)

Step 5:

Step 6:

Many thanks

Shanker V