v lookup
Train Strikes - 7th, 8th & 9th May 2024
Hide
Contact Us About Resources Consent preferences Sign in

TrustPilot

starstarstarstarstar Excellent

Request Callback We will call you back  0207 987 3777 Call for assistance Your Basket Basket is empty
Callback Sign in Basket
Menu

Call us on 0207 987 3777 or Search our website

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

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

V Lookup

resolvedResolved · High Priority · Version 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.


 

Excel articles

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

Excel tip:

Shortcut for deleting all comments in a spreadsheet

If you have entered multiple comments into a spreadsheet and wish to delete them all at once, you can achieve this by:

1. Holding down Ctrl, then Shift, then O - this will select all cells containing comments in the worksheet you are looking at.

2. Right-clicking on one of the selected cells, and selecting Delete Comment from the menu that appears.

3. Clicking anywhere else in the spreadsheet to deselect comments - all comments should have disappeared from the spreadsheet.

View all Excel hints and tips


Request Callback

We will call you back

0207 987 3777

Call for assistance

Security verified Microsoft Partner

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

Terms & Conditions Privacy & Cookie Policy Consent preferences

Server loaded in 0.05 secs.