How to use VLOOKUP on Multiple Columns || Excel Formulas and Functions || EXCEL TAMIL

How to use VLOOKUP on Multiple Columns, VLOOKUP Advanced Tips & Tricks - 8 Methods !!! (தமிழில்)

Please download the practice file here..
https://drive.google.com/file/d/1JbTV...

VLOOKUP BASICS
   • Learn VLOOKUP Function Basics || Exce...  

LEARN VLOOKUP WITH RANGE LOOKUP
   • Learn VLOOKUP with RANGE LOOKUP || Ex...  

HOW TO USE WILDCARDS WITH VLOOKUP
   • How to use WILDCARDS in VLOOKUP || Ex...  
------------------------------------------------------------------------
Video No: 18
#Tamil
#ExcelTamil
#VLOOKUP
------------------------------------------------------------------------
There are various methods available to use VLOOKUP on multiple columns, starting from basic to advanced methods:
Please watch the entire video to know all methods, and you will become expert in VLOOKUP

8 Methods with Time Stamp, click the time to go directly to the particular method:

02:00 Manual VLOOKUP on each column
05:50 Manual VLOOKUP by Reverse Method
07:30 Changing Column Name Manually
12:05 Changing Column Name using Cell Reference
15:26 Using COLUMN Function
18:48 Using COLUMNS Function
22:33 Using Arrays
27:22 Using Arrays + SUM
28:49 Using Arrays + Average
29:33 Using MATCH Function
------------------------------------------------------------------------
Please do watch our other videos:
All Videos Playlist:
   • Excel Formula's and Functions in Tamil  

UPPER,LOWER,PROPER FUNCTIONS
   • Learn UPPER,LOWER,PROPER functions ||...  

TODAY AND NOW FUNCTIONS
   • Learn TODAY & NOW functions || Excel ...  

FLASH FILL FEATURE IN EXCEL
   • Learn FLASH FILL OPTION || Excel Form...  

ORDER OF OPERATIONS (PEMDAS RULE)
   • What is ORDER of OPERATIONS || Excel ...  

GOAL SEEK OPTION IN EXCEL
   • Use GOAL SEEK function || Excel Formu...  

SUM PRODUCT FUNCTION IN EXCEL
   • How to use SUMPRODUCT Function || Exc...  

LEARN VLOOKUP WITH RANGE LOOKUP
   • Learn VLOOKUP with RANGE LOOKUP || Ex...  

HOW TO USE WILDCARDS WITH VLOOKUP
   • How to use WILDCARDS in VLOOKUP || Ex...  

HOW TO TRANSPOSE EXCEL DATA
   • How to TRANSPOSE data - Rotate Excel ...  

HOW TO SOLVE CIRCULAR REFERENCE WARNING IN EXCEL
   • How to Remove Circular References in ...  

HOW TO USE EXCEL WATCH WINDOW TOOLBAR
   • How to Use Excel Watch Window Toolbar...  

HOW TO USE CONCATENATE FUNCTION
   • Learn Concatenate Function || Excel F...  

HOW TO USE CONCAT & TEXT JOIN
   • CONCAT & TEXT JOIN - New Excel Functi...  

VLOOKUP BASICS
   • Learn VLOOKUP Function Basics || Exce...  

LEARN EXCEL ROUND FUNCTION
   • Excel ROUND Function || Excel Formula...  

LEARN EXCEL CELL REFERENCE STYLES
   • Learn Excel Reference Styles || Excel...  

LEARN RAND & RANDBETWEEN FUNCTIONS
   • How to Generate RANDOM Numbers in Exc...  
------------------------------------------------------------------------
Advanced Excel Training
Advanced Excel Training in Tamil
Advanced Microsoft Office Training
Excel
Excel Advanced Formulas in Tamil
Excel Advanced Training in Tamil
Excel Basics in Tamil
Excel Coaching in Tamil
Excel for Beginner in Tamil
Excel Formulas in Tamil
Excel Step by Step Guide in Tamil
Excel Tamil
Excel Tips and Tricks in Tamil
Excel Videos
Free Computer Training in Tamil
Free Microsoft Office Training in Chennai
Free Online Excel Training
Learn Office 365 in Tamil
Microsoft Excel Training
Microsoft Office Training in Tamil
Microsoft Office Tamil
Microsoft Office Training in Excel
MS Office
Excel Upper Lower Proper Function
Excel Today Now Function
Excel Flash Fill Option
Excel PEMDAS
Excel Order of Operations
Excel Goal Seek
Excel SUMPRODUCT Function
Excel VLOOKUP Function
Excel Range Lookup Function
Excel VLOOKUP and Wildcards
Excel Transpose Function
Excel Circular Reference Warning
Excel Watch Window
Excel Concatenate Function
Excel Concat Function
Excel Text Join Function
Excel Round Function
Excel Cell Reference Style
Excel A1 Style
Excel R1C1 Style
Excel RAND Function
Excel RANDBETWEEN Function
Excel RANDOM NUMBERS
Excel VLOOKUP on Multiple Columns
Excel VLOOKUP with Match Function
Excel VLOOKUP with Arrays
Excel VLOOKUP with Column, Columns Functions
Excel VLOOKUP usind Cell Reference
Excel VLOOKUP Advanced

#Free
#Excel
#Training
#MSOffice
#Office365
#ExcelFormulas
#ExcelTips
#ExcelTricks
#ExcelFree
#ExcelShortcuts