"ArrayFormula" syntax translation from Google Sheets -> Excel

Hi there.

Im trying to understand some differences between Sheets / Excel.

In Google Sheets I will use the alternate array formula: (Ex. {cellvalueA, cellvalueB} as a way to populate two cells with one function. I use this to autofill information from separate tabs across ranges from TabA to TabB.

I will minimize "Column A", and have the information auto-populated in "B' for 'default info' (from TabA to TabB), but can then be manually overwritten (in Tab B) without destroying the function.

How do I do the same thing in excel? Is there a different syntax or formula I can use to achieve this? Because the "{}" doesn't work the same as far as I can tell.

Specifically what I need is the ability to use a formula to populate into a cell without the formula residing in that destination cell.

Let me know if additional context is need to answer my inquiry.