Forum home » Delegate support and help forum » Microsoft Excel Training and help » V Lookups
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
V Lookups
Resolved · Medium Priority · Version 2007
Reply Wed 6 Jul 2011, 15:39Delegate Saroja said...
Saroja has attended:
Excel Intermediate course
Word Introduction course
Excel Intermediate course
Excel Advanced course
V Lookups
Fastest and simplest way to use vlookups
For upcoming training course dates see: Pricing & availability
RE: V Lookups
Hi Saroja!
The idea of a VLOOKUP is that in one cell you have a value or code e.g. an employee number in cell A2. Based on the value in A2 you want to bring in information about that employee held in a different data table.
1. Name this different table something e.g.EMPLOYEES and format it as a table if your company is growing.
2. Know which columns in the EMPLOYEES table you are interested in e.g. DeptName in column 3 and Salary in Column 6.
3. In cell B2 type your VLOOKUP formula:
=VLOOKUP(A2,EMPLOYEES,3,0)
to bring in the DeptName for the exact employee number you typed in cell A2.
4. In cell C2: =VLOOKUP(A2,EMPLOYEES,3,0) will bring in his salary.
Remember to nest this VLOOKUP inside an IF function to trap the blanks!
Hope this answers your question and thanks for the query.
Clare
Wed 13 Jul 2011: Automatically marked as resolved.
|