Vlookup cross file (by using Linq)?

I want Vlookup 2 excel files.

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

image

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

I want output as below.
image

Please guide me about it.

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

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

image

Please guide me about it.

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

Hi,

Can you try the following sample? I added sorting.

Sample20210823-3v2.zip (20.7 KB)

Regards,

@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.

Hi,

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

Sample20210823-3v3.zip (20.7 KB)

Regards,