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