eHow launches Android app: Get the best of eHow on the go.
How to Connect VB to Excel
How to Create an Excel Auto New Macro
How to Mail Merge in Excel
How to Make a Calendar Using Excel
How to Make a Form in Excel
How to Use Excel for Statistics
How to Write a Reset Macro for Excel
How to Write Macro Coding in MS Excel
Using Excel for Accounts
Using Excel for Project Management
Using Excel Macros
Using Excel Pivot Tables
Using Excel Templates
Using Excel Tutorials
Using Excel Visual Basic for Applications
Using Excel VLookup
What Is a Pull Handle in Excel?
Working Out Percentages in Excel
Excel formulas are used to perform calculations, identify trends and consolidate numbers from disparate so… More
In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "S… More
Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on… More
Creating a formula in Excel 2003 is a great way to perform mathematical calculations and basic math using … More
Microsoft Excel is a powerful tool for analyzing data. The Forecast function provides users with a way of … More
A per diem is the expenses needed to live per day. Business uses the per diem rate to determine the amount… More
Spreadsheet software offers very useful tools for both business and home applications where users are able… More
How to use Budget Formulas in this free series of personal finance video from our professional Certified P… More
There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in … More
VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to … More
After inserting data into Microsoft Excel, put the cursor into the desired cell and find the VARP function… More
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and sp… More
Microsoft Excel formulas can be used to take the sum or average of a set of data by typing an equal sign i… More
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound fun… More
Excel users can show formulas by clicking on a cell, which makes the formula appear in a text window. Lear… More
Summary: VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to an HLookup formula, which searches horizontally. Apply the VLookup formula to a spreadsheet with tips from an experienced Excel user in this free video on computer software.
Tonya Mason is an adjunct instructor and audio video equipment manager at a college in Cincinnati, Ohio. She has worked on various independent features, as well as, participated in...read more
"Microsoft Excel is a registered trademark of Microsoft Office Products, and I am in no way, shape, or form, affiliated with Microsoft Office, or Microsoft. OK, next, we want to work on something called VLOOKUP. And VLOOKUP, just basically means it's a vertical lookup. In other words, it's going to look up a number from another row or column, up from, where ever you're putting that actual value. So, if I want to actually look something up, this is the "base", formula you would want to use in your formula bar. VLOOKUP(1), the area, the range from A2-C10, and 2. The difference between VLOOKUP and HLOOKUP, is that VLOOKUP, looks for things vertically within your table, and HLOOKUP looks for things horizontally within your table."
eHow Article: Using Excel VLookup
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
