Hey there,
I currently have a sheet build (let's call it a dashboard), where there is an an area that pre-populates data from a master table and is scrollable using a form control bar. In the designated scrollable area, this is the current array formula:
=IFERROR(IF($L$28="",OFFSET('Master...