Vlookup with Two Excel Files using LINQ

Help Studio
, ,
1

Hello,
I need to perform Vlookup on two excel files F1 and F2 using LINQ ,with lookup value as column values from F1 and table range from F2 and the value to be returned from F2 and updated in column in F1 file.

Thank You,
Vishal

2

@ppr could you please help me

3

can you please share some sample date along with expected output? Thanks

1 Like
4

f1 -.xlsx (8.3 KB)
f2.xlsx (8.4 KB)
in F1 column H has to be updated , by doing vlookup with F2 and using column A from F1 as lookup value,and after there is a match in F2 take value of column G from F2 and Update in column H in F1
@ppr

thank You
Vishal

5

output will be updated in same F1 file

6

find starter help here:
UpdateDTLeft_1ColLookup_DictRixSet.xaml (11.1 KB)

1 Like
7

thanks a lot @ppr

10

hey @ppr one modification i needed , in the case very we dont find any match u have updated blank,i want to update ā€œ#N/Aā€ how can we do that

11

Change following line:
Let lkv = If(isNothing(g),ā€œ#N/Aā€,g(ā€œGā€).toString)

1 Like
12

yeah got it.Thanks @ppr

13

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.