Financial Terms Dictionary
Vertical analysis is a technique that examines the components of a number. It is shown as a percentage. For example, on the income statement, sales is 100% and everything is deducted from sales.
On the balance sheet, total assets are 100% and all the assets are components of that number. Vertical analysis is also called common-size analysis.
VLOOKUP is an Excel function that retrieves data from a specific column in a table in Excel. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches.
The “V” stands for “vertical”. Lookup values must appear in the first column of the table, with lookup columns to the right.