Automatically update LOOKUP formula when inserting additional row

[jayl007]

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?

=LOOKUP(2,1/(ISNUMBER(H50:H56)),H50:H56)

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

=LOOKUP(2,1/(ISNUMBER(H50:H57)),H50:H57)

[#2]

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: https://jkp-ads.com/articles/excel2007tables.asp