Google Sheets – Getting the value from the last row

Long spreadsheet, constantly adding rows. How do you get a value from the last row?

You could continually updated the field with the latest row number, but that’s no good.

Instead, follow the sequence in this image to get the last row number, combine it with the right column, then get the value from that cell.

Text version, for copy and pastin’

Last RowArrayFormula(max(if(len(G:G),row(G:G),)))79
Last G Row“G” & $R$1G79
Value of Last G RowINDIRECT($R$2)$17,227.78

That’s it.