Cross Excel Updation

T

test

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
 
J

Jacob Skaria

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top