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. Primary Mortgage Market

    The market where borrowers and mortgage originators come together ...
  2. 100% Mortgage

    A mortgage loan in which the borrower receives a loan amount ...
  3. Reverse Mortgage

    A type of mortgage in which a homeowner can borrow money against ...
  4. Mortgage Originator

    An institution or individual that works with a borrower to complete ...
  5. Secondary Mortgage Market

    The market where mortgage loans and servicing rights are bought ...
  6. Mortgage Pool

    A group of mortgages held in trust as collateral for the issuance ...
RELATED FAQS
  1. How safe are money market accounts?

    Learn the difference between a money market account and a money market fund. Both savings vehicles are relatively safe, but ... Read Answer >>
  2. Why is Belize considered a tax haven?

    Explore the factors that make Belize one of the most modern and corporate-friendly tax havens in the world, including its ... Read Answer >>
  3. What is an assumable mortgage?

    The purchase of a home is a very expensive undertaking and usually requires some form of financing to make the purchase possible. ... Read Answer >>
  4. Why would a homebuyer need to take out PMI (private mortgage insurance)?

    Learn why some home buyers are required to take out private mortgage insurance (PMI), and how it affects the total monthly ... Read Answer >>
  5. Why does the majority of my mortgage payment start out as interest and gradually ...

    When you make a mortgage payment, the amount paid is a combination of an interest charge and principal repayment. Over the ... Read Answer >>
  6. What are the disadvantages of a Roth IRA?

    Get informed about Roth IRAs, which have a few disadvantages, including limited access to funds and contribution limits based ... Read Answer >>
Hot Definitions
  1. Physical Capital

    Physical capital is one of the three main factors of production in economic theory. It consists of manmade goods that assist ...
  2. Reverse Mortgage

    A type of mortgage in which a homeowner can borrow money against the value of his or her home. No repayment of the mortgage ...
  3. Labor Market

    The labor market refers to the supply and demand for labor, in which employees provide the supply and employers the demand. ...
  4. Demand Curve

    The demand curve is a graphical representation of the relationship between the price of a good or service and the quantity ...
  5. Goldilocks Economy

    An economy that is not so hot that it causes inflation, and not so cold that it causes a recession. This term is used to ...
  6. White Squire

    Very similar to a "white knight", but instead of purchasing a majority interest, the squire purchases a lesser interest in ...
Trading Center