Excel Automate script return value

Question

I am seeking assistance with an Excel Automate script. (no Macros as it is disabled in my org) As this function is relatively new to me, I'm encountering difficulty in constructing a suitable formula. I want to update the table in data sheet based on the table in sheet1. and if they are not found, maintain the values in the first table unchanged. Both tables are dynamic as new data may be added periodically.

Is there a pre-existing Automate script available for this task?

Thank you!