1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide to Excel for Finance: Annuities
  5. Guide To Excel For Finance: Valuation Methods
  6. Guide To Excel For Finance: Goal Seek
  7. Guide To Excel For Finance: HLookup And VLookup
  8. Guide To Excel For Finance: Ratios
  9. Guide To Excel For Finance: Technical Indicators
  10. Guide To Excel For Finance: Advanced Calculations
  11. Guide To Excel For Finance: Conclusion

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 "Row-index_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 row-index_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: Ratios
Related Articles
  1. Personal Finance

    Microsoft Excel Features For The Financially Literate

    Here are some of Excel's functions and features that a financial professional can use to make his or her job more efficient.
  2. Investing

    Guide To Excel For Finance

    Formulas, functions and features you need to know when using Excel for financial analysis.
  3. Small Business

    How to Calculate Net Present Value (NPV) in Excel

    Learn how to calculating the net present value (NPV) of your investment projects using built-in functions from Excel.
  4. Trading

    Is Google Beginning to Lose Its Dominance in Search?

    While Google remains king on the desktop, the migration to mobile threatens its leadership in search.
  5. Tech

    How to Calculate NPV in Excel

    Daniel Jassy, CFA, shows how to calculate NPV in Excel.
  6. Trading

    A Common Base for Understanding Changes in Value

    A discussion of basis points as well as basis point calculations using Excel.
Frequently Asked Questions
  1. How do you calculate a company's equity?

    Company equity, or shareholders' equity, is the net difference between a company's total assets and total liabilities.
  2. How Can I Access a Company's Earnings Report?

    Find out how to access the quarterly and annual earnings reports for publicly traded companies, and how to listen in to company ...
  3. What Can Cause a Negative Terminal Growth Rate?

    Learn about the assumptions built into terminal valuations and in what circumstances the applied terminal growth rate might ...
  4. What Is the Effect of Price Inelasticity on Demand?

    Find out how price inelasticity of demand shows the relationship between demand and price when the price of an inelastic ...
Trading Center