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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel courses - Using V look up's

excel courses - Using V look up's

ResolvedVersion Standard

Wed 2 May 2007, 10:04 Delegate martin said...

martin has attended:
Excel Intermediate course

Using V look up's

what are v look up's used for?

Thu 3 May 2007, 10:16 Trainer Tracy said...

RE: using V look up's

Hi Martin,

Thanks for the question

The vlook up function will based on the lookup value supplied, start searching from the first column in the lookup array for the row that the lookup value appears in the table array. It will then use the lookup column argue supplied to return the value of the cell in the column specified.

Tracy

Excel tip:

Moving between split pane sections in a spreadsheet

If you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections:

F6 - Move to the next pane
Shift + F6 - Move to the previous pane

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

excel courses - Using V look up's

Using V look up's

RE: using V look up's

Excel articles

Excel tip:

Moving between split pane sections in a spreadsheet