Excel 2016 - VLOOKUP Excel 2016 Tutorial - How To Use and Do VLookup Formula Function in Office 365

In this Microsoft Excel 2016 Tutorial on Windows 10, I demo how to use the VLOOKUP function to reference different product information. VLOOKUP looks for the value in the leftmost column of a table, and then returns a value in the same row from a column you specify. By default, the table must be sorted in ascending order. The Lookup value is the value to be found in the first column of the table, and can be a value, a reference or a text string. The Table Array is a table of text, numbers, or logical values, in which data is retrieved. Table array can be a reference to a range or a range name. The column index number is the column number in table array from which the matching value should be returned. The first column of values in the table is column 1. Finally, the range lookup is a logical value to find the closest match in the first column. True or omitted; find an exact match = false. This Office 365 tutorial is meant for beginners who would like to learn more about how to use the Office Suite.

My goal is to provide you with the best learning environment possible, for all beginners of technology. Please see a list of topics below that my various playlists cover, and don't forget to like and subscribe!

Computer Fundamentals:
Computer Case Types - Dell Inspiron AMD 3656
Printer Ports and Types
The Boot Up Process
How to Get Your Computer Questions Answered
Undo Your Mistakes on Windows 10 or Apple Mac
Routers vs. Modems
What is the Cloud? Storage as a Service
Types of Internet Services on Google Android or Apple iPhone
Browsing the Web
Why Use the Cloud?
Microsoft OneDrive - Creating Uploading Downloading and Syncing

Also, check out these other playlists to improve your Office 365 and Job Search Skills

Word 2016:
Create a New Document and Insert Text
Insert and Format Graphics
Insert and Modify Text Boxes
Create a Table
Format a Table
Present a Word Document Online
Create a Research Paper in MLA Format
Insert Footnotes in a Research Paper
Create Citations and a Bibliography
Save a Document
Correct Errors as You Type
How to Format a Document in APA Format
Convert Word Document to a PDF File
Microsoft Office Specialist Certification Exam Practice Study Guide
APA Format Part 2

Excel 2016:
Create, Save, and Navigate an Excel Workbook
Enter Data in a Worksheet
How do you Export Access to Excel and Apply Conditional Formatting
Use Flash Fill, SUM, Average, Median, and MAX Functions and Formulas
Move Data and Rotate Text
Graph Data with a Pie Chart
Format a Pie Chart
MOS Prep - Basic Certification Exam Practice Study Guide
Change Fonts, Font Style, and Font Color
The NOW Function
Export Excel Spreadsheet to Access Table
The Vlookup Function

Access 2016:
Identify Good Database Design
Create a Table and Define Fields in a Blank Desktop Database
The Primary Key
 
Outlook 2016
Basic Tutorial

Job Search Skills:
Values, Attitude, and Goals

Video Requests:
Download GMetrix Test Preparation Software

Remember, the goal of my channel is for you to learn. You can request a video at any time in the comment section, and I will make the video for you. I will make tutorials and simulations and demos for whatever you'd like to learn in our class. So, I encourage you to make a request. I also YouTube Live Stream once a week to answer your questions!

Instructor A Morgan

[mirahsan]

1. In English
2. Fluent English
3. On the point explanation
4. Step by step and methodical
5. This should be #1 on Youtube Trending permanently

[idellasheart]

Very helpful. I very much appreciated you showing us the changes that could be made once the formula is in place, that helped me to better understand the function and purpose. TY

[stewartwilkinsonsnr]

Spent a lot of time watching videos on the Vlookup function, but could not understand any of them, most seemed for advance users. So got up this morning (UK) and made my coffee, thought let's keep trying to find a video that will help. There amongst a mixture of subjects was yours, I have to say a massive Thank You, your approach was so helpful and guess what I can now search my 43, 600 database of City/Towns and Villages in U.K. You example was the one for me as I had three columns, Locations (City/Town/Village), Counties and where in UK (England/Northern Ireland/Scotland/Wales). Have liked and subscribe to your channel. So might be your eldest follower at nearly 70, Excel is a great one for keeping the brain active. Regards Stewart 🔟/🔟

[kendrapeart]

SERIOUSLY THANK YOU. Fought with this function for far too many hours. Your video is simple and solved my problem. :) Thanks from Canada!

[jonchapman]

Thanks for sharing!!! I watch yours and Vanna Excel for my marketing work on VLOOKUP!

[Sunriseoflove]

Thank you so much!!! I had a test on this in my class and the textbook and powerpoints weren't making any sense. But your video made total sense.

[edelconnaughton]

Great Video! Very helpful and clear. Thanks

[jeffreyharrison]

Need to understand vlookup and pivot tables by Monday for my new job. Thank you!

[chocolatedreamgirl]

Great tutorial. You make it seem so easy to understand. Thank you, Adam!

[JG-unli]

Thanks so much! Explained so clearly and easy to understand and follow. Great tutorial.

[ricksegalCanada]

Well done, even a year later. Super helpful.

[ferialhits]

Thank you so much. this was so simple to follow and understand

[anargulessenaliyeva]

THANK YOU SO MUCH, CAN YOU PLEASE MAKE A VIDEO ON ON PYTHON FOR EXCEL SHEET USING FOR DATA VISUALIZATIONS? THAT'S WHAT I NEED,

[sammywellington]

Enjoyed this videos thank you for your time and merry Xmas to you and family.

[nanjaswart]

Dear Mr. Morgan. Just happened to stumble across your videos and they are amazing. Could you do a video on Pivot tables as I can understand it but have an issue to explain it to a colleague. Thank you kindly

[mattthomas]

not sure but Can you add vlookup automatically to fill each row install in typing the command every time

[hedywhitely]

Professor Adam Morgan, can you do a tutorial on reverse vlook ups, I am a beginner and need to learn how to do this for my job.

[lorrainefallonmcgowan]

Hi Adam looking for some guidance on the getpivotdata function.

[balaguravaiah]

HI SIR THIS IS BALU FROM NIGERIA
I WANT MORE V LOOKUP FUNCTION IN EXCEL PLEASE PROVIDE ME THANK YOU SO MUCH

[JG-hhrp]

Why you didn't made drop down list for Boxed set?? It would be easy