Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
v lookup

Forum home » Delegate support and help forum » Microsoft Excel Training and help » V Lookup

V Lookup

ResolvedVersion 2016

Thomas has attended:
Excel Intermediate course

V Lookup

Is anyone able to give me a basic breakdown of how VLookups work and the context in which they could be used please?

RE: V Lookup

Hi Thomas,


Thank you for the forum question.

The Vlookup is a very powerful Excel function used to lookup up data based on a lookup value.

You will find a good article in our blog if you follow the hyperlink below.

https://www.stl-training.co.uk/fg-95/vlookup-in-practice.html


I found two good videos explaining the Vlookup

https://www.youtube.com/watch?v=-WAEzokHSJM& ;t=13s

https://www.youtube.com/watch?v=E7gQ-PgYkMc& ;t=9s
Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 3 May 2019: Automatically marked as resolved.

Please browse our web site to find out more about
training in excel and other training courses.

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

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.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.08 secs.