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