We use the COUNTA function to count cells that contain information. We input 7:7 in the formula because it is the row that contains the information that you want to look up. Then we input False.

Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for better workflows.

In this guide, you will learn how to use Excel's advanced formulas such as INDEX-MATCH, OFFSET, and INDIRECT to enhance your data analysis capabilities.

You use these functions when you want to find values based on the value in a corresponding cell. Thanks to the newish dynamic array function XLOOKUP (), you now have more power and less confusion.