In the old 2020 spreadsheet, you could reference offset cells by entering
something like *+5.*-2 (which means 5 rows over and 2 rows down from the
current cell location) I've gone through all the help and questions I could
find, and the offset function is not what I'm really looking for.

Does excel have a function similar to above?