Cross Excel Updation
 

Greetings,

I have a requirement where I need to update a parent excel based on a
child excel. I have to compare column A of child excel with Column A
of parent excel. Wherever we have equal values, I need to pick up
respective value from Column C and D from child excel and update
Column C and D of parent excel.

For eg:

Child Excel data

Column A ColumnC Column D
test1 value1 value1
test2 value2 value2

Parent Excel data

Column A ColumnC Column D
test0
test1
test2

Final result

Parent Excel data

Column A ColumnC Column D
test0
test1 value1 value1
test2 value2 value2

So wherever we have equal values in column A of both child and parent
excel, the respective values of Column C and Column D should be picked
up from Child excel and needs to be updated in section in Parent
excel.

Can anyone please let me know how this can be achieved.

TIA

Cross Excel Updation
 

Greetings..

Paste this in parent excel
CoumnB =INDEX([Child]Sheet1!$B:$B,MATCH(A1,[Child]Sheet1!$A:$A))
CoumnC =INDEX([Child]Sheet1!$C:$C,MATCH(A1,[Child]Sheet1!$A:$A))
CoumnE =INDEX([Child]Sheet1!$D:$D,MATCH(A1,[Child]Sheet1!$A:$A))

If this post helps click Yes
--------------
Jacob Skaria