Vlookup or some other formula Help Needed

[Ghulam Qadir Mallah]

Hi there,

I have two excel files. One is source file and second target. From source file I want to copy Test Score column values to Target file's Test Score column after matching columns of Source file (name, father's name and domicile columns). I am using MS Excel 2013.

Could any body help on this as soon as possible please?

Thanks,

[#2]

Hi,

Put the formula =VLOOKUP(A2,'[Adm_Bachelor_2018_TEST SCORE.xlsx]Sheet2'!$D:$L,9,0) in Target File.

Note: If text values doesn't matched, results may vary.