Formerly Best Training
© 2024 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
Forum home » Delegate support and help forum » Microsoft Excel Training and help » 3D Formula
Resolved · Low Priority · Version 2003
Natalie has attended:
Excel Intermediate course
Interesting in receiving more information on VLookups and similar formula rather than manual input.
Hello Natalie
Thank you for your question and welcome to the forum.
Forum access is provided so if you have questions relating to the the content of the courses you have taken with us, we can provide advice and support relating to your questions.
Vlookups (and other formulas that reduce manual input) are covered as part of our Excel Advanced course, therefore you may be interested in taking Advanced level training with us.
Alternatively, I have provided a link below to a page which gives a good explanation of the VLOOKUP function:
http://www.contextures.com/xlFunctions02.html
Amanda
|
Excel tip:Using Excel's MODE functionUse Excel's MODE function to display the most common value present in a particular range of cells. |
We'll call during UK business hours
Server loaded in 0.08 secs.