Vlookup cross file (by using Linq)?

[Maria99]

I want Vlookup 2 excel files.

1. file data as below. data.xlsx (8.3 KB)

2. file master as below.
   master.xlsx (8.4 KB)

I want output as below.

Please guide me about it.

[Yoichi]

Hi,

How about simply using JoinDataTable as the following?

Sample20210823-3.zip (20.5 KB)

This sample does not input #N/A to blank cell. Do you need it?

Regards

[Maria99]

@Yoichi After run your flow , sequence in Column Mobile have change.
I want to keep sequence in Column Mobile.

Please guide me about it.

If vlookup not found , I want show blank in that column.

[Yoichi]

Hi,

@Maria99

I want to keep sequence in Column Mobile.

Can you try the following sample? I added sorting.

Sample20210823-3v2.zip (20.7 KB)

Regards,

[Maria99]

@Yoichi Sorry , If I want to change write data from column C , D , E to Column N , O , P instead.

Please guide me more about it.

[Yoichi]

Hi,

The following filter unneeded column and write remain table to N2. Can you check this?

Sample20210823-3v3.zip (20.7 KB)

Regards,

[Cristian_Negulescu]

Hello Maria,
Here I have multiple ways how to do VLOOKUP (including multiple files):

UiPath multiple use-cases Excel VLOOKUP vs LOOKUP Vs Dictionary

Thanks,
Cristian