Vlookup

Resolved · Medium Priority · Version 2003

Tue 7 Jul 2009, 16:20 Delegate Julien said...

Julien has attended:
Excel Advanced course

Vlookup

What is Vlookup and how can it be used

Tue 7 Jul 2009, 16:55 Trainer Amanda said...

RE: Vlookup

Hello Julien

Thank you for your question and welcome to the forum.

The VLOOKUP function is used to extract one piece of data from within an Excel database.

The V in VLOOKUP refers to Vertical, meaning that the data is arranged in columns.

I've attached some notes on VLOOKUP that you might find useful.

Kind regards
Amanda

Attached files...

vlookup.doc

Tue 14 Jul 2009: Automatically marked as resolved.

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

Vlookup

Vlookup

RE: Vlookup

Attached files...

Excel articles

Excel tip:

Entering text in Multiple Worksheets