ExcelVlookup data1

Help Activities
1

Hi all,

I have excel1 and excel2 I need to do vlookup and this is the formula for vlookup
=VLOOKUP(AZ2,‘[mis3418_M3dsb_report_detail_wkly_ILC_BL_Detail_17&03-2024.xlsx]Sheet1’$H:$V,15,0]
Here AZ2 is the column name of excel1, mis3418_M3dsb_report_detail_wkly_ILC_BL_Detail_17&03-2024.xlsx]Sheet1’ is the excel2 name H is column name and V is also column name of excel2.

Can anyone please help me

2

@0bb4628e217fd43ac86ac9294,

Use this formula.

=VLOOKUP(AZ2,‘[mis3418_M3dsb_report_detail_wkly_ILC_BL_Detail_17&03-2024.xlsx]Sheet1’$H:$V,15,0)

Formula should end with )

Thanks,
Ashok :slight_smile: