Jo has attended:
Excel Advanced course
VLOOKUPS
Please can I get someone to run through with me tomorrow?
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
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
