Forum home » Delegate support and help forum » Microsoft Excel Training and help » V- Look Up

V- Look Up

ResolvedVersion 365

Thu 24 Nov 2022, 16:31 Delegate 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:15 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Use shortcut keys to select rows or columns

Most users use the mouse to select rows or columns. It may be more convenient to use keyboard shortcuts to do that.

The shortcut key combination to select an entire row is Shift+Spacebar.

The shortcut key combination to select an entire column is Ctrl+Spacebar.

These are pretty easy to remember as the spacebar looks like a long row (or column if you're looking at it sideways). Remember that Ctrl, beginning with C, selects columns and Shift, by a process of elimination, the rows.

View all Excel hints and tips

V- Look Up

V- Look Up

RE: V- Look Up

Excel articles

Excel tip:

Use shortcut keys to select rows or columns