I have a column in a target sheet where I manually insert the Row Link (from Row Properties) to the corresponding row in my source sheet. I'm usually interacting with my data in the target sheet, so using that link helps me quickly find the exact place in the source sheet where I can make edits and keeps both sheets in sync.
Is there a way to create a sheet reference that will automatically pull in the URL from the Row Properties based on a unique identifier? I'm wanting it to work like INDEX-MATCH, but that only allows me to reference columns or cells.