98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL
EXCEL
Resolved · Low Priority · Version 2003
Thomas has attended:
Excel Intermediate course
Excel Advanced course
EXCEL
How do VLookup functions work?
RE: EXCEL
Hello Thomas
Thank you for your question and welcome to the forum.
The Vlookup function allows you to get Excel to look for an item in the left hand column of a table area, and display/extract a corresponding item/value from the same row and display it in another cell.
Basically it saves you from having to hunt through a list to find the item you are after, and then find a corresponding item from the same row.
We cover the VLOOKUP function as part of our Excel Advanced course:
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php
Amanda
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. |
Excel tip:Copying Formulae QuicklyThere is a quicker way of copying a formula down a column. |