98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » V- Look Up
V- Look Up
Resolved · Low Priority · Version 365
Thu 24 Nov 2022, 16:31Delegate Jess said...
Jess has attended:
Excel Intermediate course
PowerPoint Intermediate Advanced course
V- Look Up
The phrase V-Look up was used a lot throughout the session today and I feel like I might know what this, but please can it be explained?
Fri 25 Nov 2022, 13:15Trainer Martin said...
RE: V- Look Up
Hi Jess,
Thankyou for your question about VLOOKUPS
To explain a VLOOKUP, it is a formula which allows you to look for a specific thing eg. ID number in a large set of data. When it finds a match, the VLOOKUP returns a piece of information relating to that ID number (eg. revenue) and puts the answer in another sheet.
To fully understand how to build a VLOOKUP and the different ways to use it, here is a link:
https://www.youtube.com/watch?v=hwL6KKJP-_I
I hope this helps
Kind regards
Martin
Fri 2 Dec 2022: Automatically marked as resolved.
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:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |
