|
Training Index
Using and Understanding Microsoft Excel's VLOOKUP function
|
|
|
Learn how to use VLOOKUP in Microsoft Excel. Once
you've mastered the concept see how to use it in your models and what
to watch out for. The VLOOKUP command is extremely useful when
trying to extract data out of lists of information.
|
Be aware that these video clips use Windows Media Player. Click on the
hyperlink and, depending on your connection speed, you may need to wait a
few moments.
| Title |
Price
|
Video
Clip
(Windows Media Player) |
VLOOKUP
Learn how to use the VLOOKUP function in Microsoft Excel. The
VLOOKUP functions enables you to pull through various bits of
information based on some reference point.Excel Help
Description: Searches for a value in the leftmost column of a
table, and then returns a value in the same row from a column you
specify in the table. Use VLOOKUP instead of HLOOKUP when your
comparison values are located in a column to the left of the data you
want to find. The V in VLOOKUP stands for "Vertical." |
FREE
|
|
 |
Handling Large VLOOKUP
tables
Once you have mastered VLOOKUP you may find that you use it for
large datasets. The problem is that when you make changes to your
spreadsheet you sometimes need to go through all the VLOOKUP cells and
change the column reference. Learn how to avoid this! |
FREE
|
|
|
Typical errors made when
using VLOOKUP
As useful as the VLOOKUP function is, there is a significant risk
of errors. Learn what you must watch for. |
FREE
|
|
|
Automatic Sorting of lists
By combining the VLOOKUP and RANK functions you can have Excel
automatically sort a list of data into a specific order. |
FREE
|
(5 min) |
|
|
Quote of the page:
A computer lets you make more mistakes faster than any invention in
human history- with the possible exceptions of handguns and tequila-
Mitch Ratliffe
|
|
|
Visit our
training page for a full list of the
training available on the site. |
Do you like what you see. Tell your friends. If you have a
training coordinator
at your organisation tell them that there is free excel training available
at this site.
Don't like what you see. Tell us at
training@AuditExcel.co.za .
Do you have suggestions of what you would like to see. Tell us at
training@AuditExcel.co.za .
|
