# Automatically update LOOKUP formula when inserting additional row

Occasional Visitor

# 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 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)