Learn how to create your own VLOOKUP formula in Microsoft Excel during the first 5 minutes of this video! Stay tuned for the remainder of the video to learn a few extra tips and tricks.

Excel Tutorials: [ Ссылка ]

Sample data set used in this video: [ Ссылка ]

Chapters
0:08 What is a VLOOKUP?
0:20 Example of when a VLOOKUP is needed
0:40 Components of the VLOOKUP formula
1:31 Creating a VLOOKUP formula
5:00 Returning in a different value from reference table
5:40 Quickly replicating formula in sample table
6:06 Common errors
8:00 Referencing a table on a different sheet or tab

#MicrosoftExcel #Excel #vlookup #Exceltutorial

свернуть