Google Sheets has an INDIRECT function that lets users use relative row references in formulas.
For example, instead of using a formula like
=A2+B2, you can replace the row numbers with a variable referencing the current row. This way, you don't have to worry about whether the references for the current row are correct if your formula only deals with data in the current row.
This is particularly useful if you're pushing the formula to …Read more