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 column...
Excel Desktop
Formulas & Functions
Logaraj Sekar's avatar
Logaraj Sekar
Iron 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