Apr 29 2018
04:42 AM
- last edited on
Jul 25 2018
11:52 AM
by
TechCommunityAP
Apr 29 2018
04:42 AM
- last edited on
Jul 25 2018
11:52 AM
by
TechCommunityAP
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,
Apr 29 2018 10:41 PM
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.