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.

Patreon: https://www.patreon.com/ThatOfficeGuy
Learn to SUM: https://www.youtube.com/watch?v=T3fpvXtjQpg
Learn to Match INDEX: https://www.youtube.com/watch?v=_LKZasC-HZo&t=6s

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

Видео How to perform a VLOOKUP but why you shouldn't... канала That Office Guy