Forum home » Delegate support and help forum » Microsoft Excel Training and help » ms excel training london - VLook Up
Hi Keeley,
Thanks for the question
The vlook up function is based on the lookup value supplied, start searching down from the first column in the lookup array for the row that the lookup value appears in the table array. It will then use the lookup column arguement supplied to return the value of the cell in the column specified.
Tracy
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
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
Primarily Excel is set up to sort data that is stored in columns rather than rows.
It is possible to get Excel to sort data stored in rows however.
Click in the row you want to sort, or select the cells in the rows you wish to sort.
Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.
TrustScore
4.9
/ 5
2394 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.
