From specific cell end of the sheet
I have a project template in which I would like to use a formula that allows me to search in a range that starts at a specific cell but ends at the last line of the sheet. In some sheets I have 100 rows and in some sheets I have 500 rows so I can't put, for example, [Actual Material Costs]2:[Actual Material Costs]500 in my template because if I have less rows it gives me an error and if I have more rows that are added over time I won't get the data from row 501. Is there a way to replace the 500 with a "last line" indication?
Help Article Resources
Check out the Formula Handbook template!