Automatically update LOOKUP formula when inserting additional row

Occasional Visitor

I want to find the last number in a column starting from a specific cell. However, when I add a new row, I need to update the formula manually to include the new row. Is there a way to have the formula below automatically update when inserting an additional row?



Currently, I am updating the formula manually to this. For this example, I would update H56 to H57:



Screen Shot 2021-08-06 at 12.56.09 PM.png

1 Reply
This is one of the great features that converting a range to a table brings you: never update a cell reference again when data is added: