Next Live Training Date:

10-14 Nov JHB, 18-20 Nov CT

VLOOKUP Tutorials

VLOOKUP Tutorials

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.¬†This command is extremely useful when trying to extract data out of lists of information. Below are links to the Excel video tutorials touching on this lookup command.

Related:  VLOOKUP Exercises page

VLOOKUP- click here to see tutorial

Learn how to use the VLOOKUP function in Microsoft Excel. The function 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 V-LOOKUP instead of H-LOOKUP when your comparison values are located in a column to the left of the data you want to find. The V in V-LOOKUP stands for “Vertical.”

Handling Large VLOOKUP tables- click here to see tutorial

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!

Typical errors made when using VLOOKUP- click here to see tutorial

As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.

Automatic Sorting of lists- click here to see tutorial

By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order.

Related Topics

This function and others are covered in our online training courses. Visit the Online training course page to see the options.

Author: Adrian miric

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Handy Tips & Tricks

What is PowerPivot

What is PowerPivot PowerPivot is a new ‘free’ tool available in Excel 2010 and Excel 2013 (be careful as it currently does not work in all versions of these two). International experts believe this is a quantum leap in Excel … Continue reading

Powermap Introduction

Powermap Introduction If you make use of Excel 2013 then you should seriously look at getting the free PowerMap add in that allows you to visualise information using a map as the background. As a quick example we used the … Continue reading

We have used AuditExcel over the last 5 years to develop large scale property modelling developments. All the templates are still in use and allow for intricate sensitivity analysis. As a result we are better able to assess projects and choose the optimal ones. Their response times also make it easy to rely on them for new developments.

– Property Modelling- Basil Read

Video Library & Tutorials //

View Entire Video Gallery ››

Excel see formula instead of value 2013

Excel see formula instead of value 2013

Excel Quick Sum 2013

Excel Quick Sum 2013

Excel Group Rows 2013

Excel Group Rows 2013

Excel text top of cell 2013

Excel text top of cell 2013

Some of our Featured Clients