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

excel

ResolvedVersion 2007

saul has attended:
Excel Intermediate course

Excel

What's a v lookup formula?

Thanks

RE: Excel

Hello Saul

Thank you for your question and welcome to the forum.

The VLOOKUP function is used to get Excel to look for a particular item on the left hand side of a table, and extract a corresponding item from another cell in the same row - so it saves you from having to hunt through a list of data for a particular item.

VLOOKUP is covered as part of our Excel Advanced course.

Kind regards
Amanda

Thu 4 Dec 2008: Automatically marked as resolved.

Excel tip:

Copying the same value, label or formula quickly into a range of selected cells.

Select your range of cells. Type the value, label or formula that you want to appear in all the selected cells and then press Ctrl+Enter.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.