Automatically update LOOKUP formula when inserting additional row

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 formu...