Financial Terms “H”

Financial Terms Dictionary



The HLOOKUP function is an Excel function that retrieves data from a specific row in a table in Excel. HLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The “H” stands for “horizontal”. Lookup values must appear in the first row of the table, with lookup rows below.

Horizontal Analysis

Horizontal analysis is also called trend analysis. This trend is usually a percentage change of an account over several years. If sales increases from $2,000 to $2,200 in one year, that is a 10% increase in sales. If accounts payable goes from $500 to $400, that is a 20% decrease.

Jeff Mankin

Jeff Mankin teaches financial literacy. His website is

Recent Posts

link to Expense


What is an expense? Expense is a cost to operate a business to produce revenue. In accounting, an expense occurs when an asset is used. This could include a cash outflow or consuming an...