Cross Excel Updation

  • Thread starter Thread starter test
  • Start date Start date
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
 
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

Similar Threads

if then multiple sheets and values 2
User Form 5
spread out fields in different column 1
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Parsing a text field to retrieve numeric values 7
conditional formatting for ratios between rows? 3
Issue with conditional formatting - Formula changing 1
VBA Compare part of cell to another cell and then calculate 0

Back
Top