Guide To Excel For Finance: HLookup And VLookup
AAA
  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

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 "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

  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
RELATED TERMS
  1. Earnings Per Share - EPS

    The portion of a company's profit allocated to each outstanding ...
  2. Return On Investment - ROI

    A performance measure used to evaluate the efficiency of an investment ...
  3. Mass Index

    A form of technical analysis that looks at the range between ...
  4. Money Flow Index - MFI

    A momentum indicator that uses a stock’s price and volume to ...
  5. On-Balance Volume (OBV)

    A momentum indicator that uses volume flow to predict changes ...
  6. Negative Volume Index - NVI

    A technical indicator that relies on changes in a security’s ...
  1. Why is divergence between indicators important for traders?

    Learn what technical analysts mean by a "divergence" between indicators, and determine why a divergence could be a sign the ...
  2. What does it mean when a stock is trading near the Donchian channel, high or low?

    Learn how Donchian channels can be used to spot overbought or oversold positions and how to react to these signals to make ...
  3. Is using the Donchian channel more risky or more conservative than using Bollinger ...

    Read about differences between Bollinger Bands and Donchian Channels, and learn why the latter are considered to be a riskier ...
  4. How effective is creating trade entries after spotting a Morning Star pattern?

    Understand the elements of the morning star candlestick pattern and how to best utilize this reversal signal to create effective ...

You May Also Like

Related Tutorials
  1. Investing Basics

    Industry Handbook

  2. Fundamental Analysis

    Discounted Cash Flow Analysis

  3. Fundamental Analysis

    Ratio Analysis Tutorial

  4. The NYSE floor excitement after a rebound. Being a stock trader can be highly gratifying.
    Active Trading Fundamentals

    Introduction to Stock Trader Types

  5. Trading Strategies

    Guide to Pairs Trading

Trading Center