Forum Discussion

Ghulam Qadir Mallah's avatar
Ghulam Qadir Mallah
Copper Contributor
Apr 29, 2018

Vlookup or some other formula Help Needed

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,

Excel Desktop
Formulas & Functions
  • Logaraj Sekar's avatar
    Logaraj Sekar
    Steel Contributor
    Apr 30, 2018

    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.

Resources