1. Guide To Excel For Finance: Introduction
  2. Guide To Excel For Finance: Goal Seek
  3. Guide To Excel For Finance: PV And FV Functions
  4. Guide To Excel For Finance: HLookup And VLookup
  5. Guide To Excel For Finance: Linking Yahoo! Finance and Other Outside Financial Data To Excel
  6. Guide To Excel For Finance: Ratios
  7. Guide To Excel For Finance: Technical Indicators
  8. Guide To Excel For Finance: Valuation Methods
  9. Guide To Excel For Finance: Advanced Calculations
  10. 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: Linking Yahoo! Finance and Other Outside Financial Data To Excel

Related Articles
  1. Investing

    How Do You Calculate Beta In Excel?

    If the right data on key variables is available, you can use Excel to calculate beta.
  2. Tech

    Advisor Tools: To ‘Excel’ or Not Excel?

    Microsoft Excel has been a staple of the financial services industry for decades but specialized advisor software solutions have sprung up in recent years.
  3. Small Business

    Calculating Net Present Value at Different Points Using Excel

    Calculating the net present value (NPV) of your investment projects using Excel.
  4. Investing

    LinkedIn Debuts New Search Feature (LNKD)

    Remember when intranets were hailed as the answer to internal communication struggles, particularly within large organizations? Well, after conducting some research on the use of the once-popular ...
  5. Investing

    Building An Effective Watch List

    An effective watch list will uncover opportunities missed by other traders, fund managers and market timers.
  6. Retirement

    Consolidating Your Retirement Money

    By midlife, you're likely to have accumulated a string of IRAs, 401(k)s and the like. This tutorial helps you organize them around your retirement goals.
  7. Tech

    Explaining Clients Why They Need a Budget

    The truth is that budgeting isn't just for times when your money is tight or your life is undergoing a major transition. Budgeting is for everyone, rich and poor alike.
  8. Personal Finance

    Buying a New Home? Here Are the Costs You Need to Know

    Here's a look at many of the costs that come with buying a home.
Frequently Asked Questions
  1. What is the difference between yield and return?

    While both terms are often used to describe the performance of an investment, yield and return are not one and the same ...
  2. What are the Differences Among a Real Estate Agent, a broker and a Realtor?

    Learn how agents, realtors, and brokers are often considered the same, but in reality, these real estate positions have different ...
  3. What is the difference between amortization and depreciation?

    Because very few assets last forever, one of the main principles of accrual accounting requires that an asset's cost be proportionally ...
  4. Which is better, a fixed or variable rate loan?

    A variable interest rate loan is a loan in which the interest rate charged on the outstanding balance varies as market interest ...
Trading Center