excel

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL

EXCEL

resolvedResolved · Low Priority · Version 2003

Thomas has attended:
Excel Intermediate course
Excel Advanced course

EXCEL

How do VLookup functions work?

RE: EXCEL

Hello Thomas

Thank you for your question and welcome to the forum.

The Vlookup function allows you to get Excel to look for an item in the left hand column of a table area, and display/extract a corresponding item/value from the same row and display it in another cell.

Basically it saves you from having to hunt through a list to find the item you are after, and then find a corresponding item from the same row.

We cover the VLOOKUP function as part of our Excel Advanced course:
https://www.stl-training.co.uk/excel-training-in-london-2003-advanced.php

Amanda


 

Excel tip:

Copying Formulae Quickly

There is a quicker way of copying a formula down a column.

Just point and double click on the black autofill handle in the right hand corner of a cell.

This will work providing you have some data in the column to the left of the column.

Sandy

View all Excel hints and tips


Server loaded in 0.11 secs.