Guide To Excel For Finance: HLookup And VLookup
HLookup
The "HLookup" function in Excel is used to easily find data in a very large database or string of values housed in an Excel workbook. It stands for horizontal lookup, or looking across a set of rows in a spreadsheet. The inputs, which are detailed below, include a lookup value ("Lookup_value," or the specific figure you are looking for in a database of figures. The table array ("Table_array") defines the part of the database you are looking for. The "Rowindex_num" input defines the horizontal row where you are looking to find the data. Finally, "Range_lookup" will help you find either the exact number you are looking for or the closest number available.
For example, suppose you have three products, each selling for $25, $55 and $75, respectively, and you record the quantities of each product sold on a spreadsheet. If you want to look up the amount of items sold for $55, simply input the =hlookup function. Under lookup_value, put the cell number of the desired figure you are searching for (in this case, $55.) Next, select a table array, which the function will use to search through your data. Finally, under rowindex_num, insert the row number where the quantity will be found under the price you are searching for. If done correctly, =hlookup will result in a value of 17.
VLookup
As you might have already guessed, the VLookup function is similar to HLookup, but the data you are looking for will be vertical, or in a column in Excel. The inputs are actually the same, the only difference will be how the data in an Excel file database are arranged. Returning to the above example, the price and quantities would be listed vertically in an Excel column.
Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel

Aggregate Function
A mathematical computation involving a set of values rather than ... 
Extended Normal Costing
In managerial accounting, a method of tracking production costs ... 
Quantity Demanded
A term used in economics to describe the total amount of goods ... 
Horizontal Well
A well that is turned horizontally at depth, and that allows ... 
Goal Seeking
The process of finding the correct input when only the output ... 
Vertical Well
A well that is not turned horizontally at depth, and which allows ...

How do I perform a financial analysis using Excel?
Find out how to perform financial analysis through Microsoft Excel, which is probably the most widely used software among ... Read Answer >> 
How can you calculate your cash budget in Excel?
Using Excel to track income and spending, estimate the effects of lifestyle changes, and present the information in ways ... Read Answer >> 
How do you calculate variance in Excel?
Calculate instantly the statistical variance of any set of numbers in Microsoft Excel with ease by using a simple builtin ... Read Answer >> 
What's an easy way of calculating gross sales in Excel?
Use Excel to calculate gross sales, display sales data, and establish a template that allows for extensive sales calculations ... Read Answer >> 
How can I calculate the hurdle rate in Excel?
Learn how to evaluate potential investments. Common desktop software provides functions that can help make the decision with ... Read Answer >> 
How can I calculate the times interest earned in Excel?
Read about a simple way to calculate times interest expense by using Microsoft Excel. TIE is a common ratio used to evaluate ... Read Answer >>