Vertical Analysis When you conduct vertical analysis, you analyze each line on a financial statement as a percentage of another line. Vertical analysis is therefore a proportional analysis method.

Available in Excel 2021 and Microsoft 365, XLOOKUP simplifies retrieving data from both vertical and horizontal datasets, making it a powerful tool for modern data analysis.