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

    A mathematical computation involving a set of values rather than ...
  2. Extended Normal Costing

    In managerial accounting, a method of tracking production costs ...
  3. Quantity Demanded

    A term used in economics to describe the total amount of goods ...
  4. Horizontal Well

    A well that is turned horizontally at depth, and that allows ...
  5. Goal Seeking

    The process of finding the correct input when only the output ...
  6. Vertical Well

    A well that is not turned horizontally at depth, and which allows ...
RELATED FAQS
  1. 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 >>
  2. 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 >>
  3. 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 built-in ... Read Answer >>
  4. 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 >>
  5. 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 >>
  6. 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 >>

You May Also Like

Hot Definitions
  1. Yield Curve

    A line that plots the interest rates, at a set point in time, of bonds having equal credit quality, but differing maturity ...
  2. Stop-Limit Order

    An order placed with a broker that combines the features of stop order with those of a limit order. A stop-limit order will ...
  3. Keynesian Economics

    An economic theory of total spending in the economy and its effects on output and inflation. Keynesian economics was developed ...
  4. Society for Worldwide Interbank Financial Telecommunications ...

    A member-owned cooperative that provides safe and secure financial transactions for its members. Established in 1973, the ...
  5. Generally Accepted Accounting Principles - GAAP

    The common set of accounting principles, standards and procedures that companies use to compile their financial statements. ...
  6. DuPont Analysis

    A method of performance measurement that was started by the DuPont Corporation in the 1920s. With this method, assets are ...
Trading Center