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.
NEW: Go to VLOOKUP Explanations with downloadable exercises and detailed solution
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.”
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!
As useful as the VLOOKUP function is, there is a significant risk of errors. Learn what you must watch for.
By combining the VLOOKUP and RANK functions you can have Excel automatically sort a list of data into a specific order.
This function and others are covered in our online training courses. Visit the Online training course page to see the options.
Please fill in your details below to receive the free monthly Audit Excel newsletter which covers free Excel tips tricks and shortcuts.
Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
If you are thinking of running a sweepstakes, and want to find a sweepstakes kit for Euro 2016 you can do one of 2 things: Run a simple paper based sweepstakes, or Run a Euro 2016 score prediction sweepstakes, which … Continue reading
We recently received the following question with regards our Euro 2016 Office pool Excel spreadsheet. …. there are a few things I don’t understand about the scoring system. Particularly, “Correctly guessing the net goals and the correct way e.g. you choose … Continue reading
...AuditExcel are professional, technically competent and provide solution suited to individual business needs. We are still using the reports and the budget tool they designed and have since been able to enhance the reports ourselves– Spreadsheet budget app- BDO Auditors