A vlookup is a function which
allows a given value to be looked up from within a table, and an
alternative column to be returned from that table.
It can also return the closest match to the value being looked up so that each row in the table can represent ranges of values.
The table being looked into can be within a different spreadsheet to
the one currently being worked on, and this spreadsheet can be shared
between multiple users.
There are many advantages to using a vlookup. The main advantages are
enhanced presentation (data can be looked up and displayed on a form),
and that tables of values don't need to be repeated on the spreadsheet,
significantly reducing space and data maintenance issues.
Once a formula for a lookup has been set up, it can quickly and easily
be copied to different areas in the spreadsheet so that it can refer to
adjacent cells in a list. An example is shown below;
(notd above example shows 3 vlookups - the middle value couldn't be found. Note also the VLOOKUP assistant icon highlighted)
The vlookup function can be entered directly in a cell, by using Insert, Function, or by clicking on the Insert Function icon
Using the Insert Function options are better option for the novice because they open the "Function Arguments" window (shown below) which prompt you for each piece of information required, and offers help.
The arguments that should be specified for the vlookup are;
VLOOKUPs can go wrong or be difficult to set up, Add-innovation provides the VLOOKUP assistant to help ;