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