How to perform a VLOOKUP but why you shouldn't...

In this video I walk you through how to create a VLOOKUP in Microsoft Excel and talk through some of the risks that come from the formula.

Topics Covered:
VLOOKUP function
Errors with VLOOKUP
MATCH function
INDEX function

Welcome to That Office Guy's Beginner's Guide course to Excel. In this course you to Learn MS Excel in easy steps and simple to understand terms. In this Microsoft Excel Basics course we will start from the basics and move towards the Expert / Master level in Microsoft Excel. This MS Excel course provides beginners with basic & intermediate Excel Skills, Tips, and Tricks. In this course we will learn how to Enter and edit Excel data, Format numbers, fonts and alignment, create simple pivot tables and charts, simple Excel formulas, How to Use Excel Functions IF, OR, SUM and VLOOKUP. Learn all the common Excel functions used in any Office, How to Create dynamic reports, Build Excel formulas to analyze date, text fields, values and arrays and much more advanced stuff.

#Excel #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excel #excelCompleteCourse #ExcelFormulas #ExcelFunctions

[ThatOfficeGuy]

If anyone has any Excel Questions they would like the answers to please comment below and I will get back to you.

Also if you liked the video please smash the like button, and if you have not already please subscribe and click the bell notification!