10 Ways to use Vlookup in Excel

In this video we will discuss 10 ways to use Vlookup in Excel.

Vlookup stands for Vertical Look up. It is one of the most frequently used functions in Excel.

VLOOKUP is an Excel function to look up data in a table organized vertically. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP.

VLOOKUP can only look to the right. The data you want to retrieve (result values) can appear in any column to the right of the lookup values.
When you use VLOOKUP, imagine that every column in the table is numbered, starting from the left. To get a value from a particular column, provide the appropriate number as the "column index".

Purpose
Lookup a value in a table by matching on the first column
Return value
The matched value from a table.
Syntax
=VLOOKUP (value, table, col_index, [range_lookup])
Arguments
value - The value to look for in the first column of a table.
table - The table from which to retrieve a value.
col_index - The column in the table from which to retrieve a value.
range_lookup - [optional] TRUE = approximate match (default). FALSE = exact match.

Download the practice files from the link below
https://bit.ly/3qLw0IV

Index
00:00 Intro
00:21 1. Vlookup Basic
02:56 2. Vlookup on a different sheet in the same file
04:50 3. Vlookup using TABLES
08:23 4. Vlookup from different file
11:05 5. Vlookup Approximate for Numbers
13:52 6. Vlookup Approximate for Dates
15:24 7. Vlookup Space Errors
16:31 8. Vlookup Text vs Number Format Errors
17:49 9. Vlookup Number vs Text Format Errors
19:08 10.Vlookup with Multiple Criteria

The VLOOKUP function does not handle multiple criteria natively. However, you can use a helper column to join multiple fields together, and use these fields like multiple criteria inside VLOOKUP.



Also, check these videos if you want to learn more

1 Min Excel: If you enjoy short videos check this section
   • Shorts : Random  

Excel: Check this playlist for Excel-related things
   • Excel  

Keyboard Shortcuts: Check this section to save some time in everyday excel work
   • Excel Keyboard Shortcuts  

Pivot Tables: Check this playlist for Pivot Table, Slicers, and Auto refreshing reports
   • Pivot Tables  

Power Query: Check the Power Query playlist for Data Preparation & its Automation
   • Power Query  

Power BI: Check the PowerBI related videos for Business Intelligence, Dashboard & Visualisations
   • Power BI  



Please subscribe to our channel and Follow us on other social media platforms for regular updates :

Tiktok https://vm.tiktok.com/ZSH28XEt/
Facebook   / datacense  
Twitter   / datacense  
LinkedIn   / datacense  
Instagram   / datacense32