Forum home » Delegate support and help forum » Microsoft Excel Training and help » VLOOKUPS
|
|
|
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. |
VLOOKUPS
Resolved · Low Priority · Version 2007
Reply Tue 15 Feb 2011, 16:33Delegate Jo said...
Jo has attended:
Excel Advanced course
VLOOKUPS
Please can I get someone to run through with me tomorrow?
For upcoming training course dates see: Pricing & availability
RE: VLOOKUPS
Hi Jo
Thanks for your question
can you please clarify your requirements? Do you require a quick overview of how VLookups work?
Thanks
Stephen
Reply Thu 3 Mar 2011, 15:41Delegate Jo said...
RE: VLOOKUPS
It is a general question really, I still cannot the concept right!!! any help on Friday would be appreciated or Thursday afternoon... thank you
RE: VLOOKUPS
Hi Jo,
Here are a few things you need to know about using Vlookups.
The formula syntax is as follows:
VLOOKUP(Lookup Value,Data Range,Column No.,True/False)
The formula defaults to TRUE in the last section, which will lookup the next approximate value in your lookup column. If you require an 'exact match' then choose FALSE.
Your data must be 'clean' i.e. there should be no blank columns or rows within the data area. There should not be any cells that have 'merge and centre' settings which are adjacent to your data.
1) Use a data table in Excel that has two or more columns of data
2) The first column (left most) is the 'lookup' column
3) Click in this column and Sort in ascending order
4) Choose a blank cell and enter a value which your formula must find in the first column of your data table, then create a Vlookup formula in the cell adjacent to this.
5) The Vlookup formula will look for the value you specify in the first column... then the focus moves across the row and will stop at the column number you indicated in the formula.
Try out a simple example for test purposes, then you can try out the formula on real data.
I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?
Have a great day.
Regards,
Rodney
Microsoft Office Specialist Trainer
|