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,

Attached Images

	Source Sheet.png (50.9 KB, 18 views)
	Target.png (46.2 KB, 17 views)

Hi and welcome
in the future please post in the correct forum. I moved your thread for you this time.
Please post a sample sheet ( click Go advanced - Manage attachments) showing data and expected results.
Pictures are nice to look at but worthless to work with.
Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

The formulas will be easier to write, easier to read, and will added automatically to new records (so long as the formula in column remains same), when you define both of your tables as Tables (Insert > Table, and give a meaningful name e.g. tSource and tTarget). NB! All columns in Table must have headers, so add header Area to second table too. And avoid apostrophes (and as best spaces too) in headers - like FathersName vs. FATHER's NAME.

Now select any cell in column TestScore (e.g. T2), and enter the formula
If TestScore in tSource is numeric
If TestScore is string, then convert it to number, or add field SNumber to 2nd table too and use VLOOKUP function: