» Vlookup Formula – Organizing the Data Table
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
The Vlookup formula searches for the lookup criteria in the leftmost column of the data table. It is recommended that the whole sheet be used as the data table, so that Vlookup will automatically look at column A as the leftmost column.
Defining a Name for the sheet (to use it as the Table_array (the second argument in the Vlookup formula) will eliminate the need of updating the range reference in any Vlookup formula.
To define a Name for the sheet:
1. Select a cell, and click Select All (the button at the top-left corner of the intersection between rows and columns).
OR
Press Ctrl+A. (In Excel 2003, press Ctrl+A+A when selecting a cell in a region.)
2. Press Ctrl+F3, and in the Names in workbook box, type the Name for the data table.
3. Click OK.
Book Store:
Recommended Books:
- Microsoft PowerPoint Version 2002 Step by Step
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Monte Carlo Methods in Finance
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Windows XP Inside Out
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
how do we compare to columns
praveen
Hi,
I want to compare 2 columns and want to get common values in the 3rd column. How can i do this in excel?
Thanks and regards,
Praveen...
How to assign a maximum limit for a value
Rajendra
How do I assign a vaule for a cell which should not be increased beyond specified value
How to compare 2 columns
Ramesh
I have data in 2 columns i.e. A & B. I want to find out whether column A value available in Column B.
A B
x1 y1
x2 z1
x3 x1
x4 x2
In the above 2 columns x1 & x2 is available in both the column. I want to know how to do the same.
PMT
Sharareh Razavi
i want to know in detail what is PMT formula in excel and how it calculates the figures.
For exxample :
we have loan amount is : 20000
Interest rate is : 8%
Time period is : 12 x 3 = 36 month
My Problem is like to Arvind, please guide me as soon as possible
Razavi
Managing Director
MOBILE:0098 912 2836025
Office: 0098 21 22953000
Email: shrazavi@rdonet.com
Fax: 0098 21 22960113
after applying PMT value is cominf 626.73.
please let me know how 626.73 is coming.
Diffrence between DATE?TIME
Bhavesh Bhatt
I have table with two field User, Date I want to calculate difference between two user for perticular user.
For exxample :
we have loan amount is : 20000
Interest rate is : 8%
Time period is : 12 x 3 = 36 month
after applying PMT value is cominf 626.73.
please let me know how 626.73 is coming.
Arvind
9891051016