How to apply Vlookup between 2 sheets?

Help Studio
, ,
1

Hi All,

I need to apply the vlookup between 2 sheets as attached:

the common column between the two excels are “bill_identifier”(Column) from excel( Ageing_Modmed_08.04.2023)and “Bill ID”(Column M) from excel(Modmed Ar detail Report - 08-05-2023), after applying the vlookup I need to fetch the “Bill Link” column as output from the excel (Modmed Ar detail Report - 08-05-2023)(Column S) and output to be write in the column(“dx3”) (Column P) in the excel ( Ageing_Modmed_08.04.2023).

Please suggest me to write the linq query.

=VLOOKUP(A:A,‘[Modmed Ar detail Report - 08-05-2023.xlsb]Sheet1’!$H:$S,12,0)
when I apply the vlookup manually the above expression is giving the correct output.

@ppr
@yoichi
@Gokul001
@vishal.kp
@ushu

2

Hey @Vrishchik , you can refer Vlookup between two different excel file sheets

3

Ageing_Modmed_08.04.2023.xlsx (908.3 KB)
Modmed Ar detail Report - 08-05-2023.xlsx (8.9 MB)