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!

Answer 1

I also would like to know of a function that does this and also have macros disabled at the organization level. current solution is enabling iterative formulas and have an if statement that returns current value

go to file - options - formulas and click enable iterative formulas

then insert statement similar to below as part of your formula

=if(a2<>"", a2, "")

if a2 is not blank keep a2 else leave blank