How to use VLOOKUP on Multiple Columns || Excel Formulas and Functions || EXCEL TAMIL
HTML-код
- Опубликовано: 6 окт 2024
- How to use VLOOKUP on Multiple Columns, VLOOKUP Advanced Tips & Tricks - 8 Methods !!! (தமிழில்)
Please download the practice file here..
drive.google.c...
VLOOKUP BASICS
• Learn VLOOKUP Function...
LEARN VLOOKUP WITH RANGE LOOKUP
• Learn VLOOKUP with RAN...
HOW TO USE WILDCARDS WITH VLOOKUP
• How to use WILDCARDS i...
------------------------------------------------------------------------
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 Fu...
UPPER,LOWER,PROPER FUNCTIONS
• Learn UPPER,LOWER,PROP...
TODAY AND NOW FUNCTIONS
• Learn TODAY & NOW func...
FLASH FILL FEATURE IN EXCEL
• Learn FLASH FILL OPTIO...
ORDER OF OPERATIONS (PEMDAS RULE)
• What is ORDER of OPERA...
GOAL SEEK OPTION IN EXCEL
• Use GOAL SEEK function...
SUM PRODUCT FUNCTION IN EXCEL
• How to use SUMPRODUCT ...
LEARN VLOOKUP WITH RANGE LOOKUP
• Learn VLOOKUP with RAN...
HOW TO USE WILDCARDS WITH VLOOKUP
• How to use WILDCARDS i...
HOW TO TRANSPOSE EXCEL DATA
• How to TRANSPOSE data ...
HOW TO SOLVE CIRCULAR REFERENCE WARNING IN EXCEL
• How to Remove Circular...
HOW TO USE EXCEL WATCH WINDOW TOOLBAR
• How to Use Excel Watch...
HOW TO USE CONCATENATE FUNCTION
• Learn Concatenate Func...
HOW TO USE CONCAT & TEXT JOIN
• CONCAT & TEXT JOIN - N...
VLOOKUP BASICS
• Learn VLOOKUP Function...
LEARN EXCEL ROUND FUNCTION
• Excel ROUND Function |...
LEARN EXCEL CELL REFERENCE STYLES
• Learn Excel Reference ...
LEARN RAND & RANDBETWEEN FUNCTIONS
• How to Generate RANDOM...
------------------------------------------------------------------------
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
Super sir I very very happy your explain semmeeee
Thank you very ♥️♥️♥️
Your way of explanation good and fine.. I have seen many vlookup videos. This one was masterpiece. Pls upload Macro recording details video...
Thanks brother, for your valuable feedback
Thanks...
Welcome
Thank you, Very much.
Thanks
Welcome
Very useful, well organized content, explained very patiently and clearly 👍apt example used.
Thank you for your valuable feedback
Very useful bro thank you
THANK YOU BRO, I LEAN LOTS FROM YOU
Vera mari, Vera mari, various methods in one video, very nice bro...
Thanks brother
. அருமையான பதிவு🙏
Nice
Thanks
Super, this is what I expected. Thank u so much😊😊
Thank you brother
Very useful brother, match function with vlookup combination trick is very amazing trick👌👌
Thanks brother, for your valuable feedback
Very useful bro thanks a lot
Thanks brother
Sir excellent
Pls help me. I need a help. How to match 3 column values and get the 4th column value.? Which formula I can use?
VERY GOOD TECHNIQUES ,YOU ARE DOING VERY GOOD JOB
Thank you
Very very useful, like your order of explanation.
Thank you brother
@@EXCELTAMIL make a video for pivot table details on Excel
Super sir, thank you
Thank you
நிறைய கற்றுக் கொண்டேன். நன்றி
Thanks bro
Vlookup la evlo panna mudiyumaa bro
It's really awesome to increase our productivity
Thanks brother
Its very useful to me... After apply this formula.. How to remove the formula.. Pls explain
Sir,
Please upload power query and Power BI video's
Sir Excel macros oda basis solla mudiyyumma?
Really wowww..... Superb. I have one doubt... Can u help me?
Worth bro..😊
Superb 👍🙏🙏🙏
நன்றி!!
Very useful my friend
Thank you
Thanks Anna
Thanks bro
Amazing
Nice sir 👍👍👍 I have one doubt, intha video la last one match function ah same time all cell Kum lookup pannamudiuma?
நன்றி
Thanks
Super
Super good 👍👍
Thanks
Super sir
thank you sir
Table Array la left side la vlookup panna mudiyuma?
Thank you 🙏
No brother, we can use index & match function to do left vlookup, i will post the video soon
@@EXCELTAMIL Thanks bro 🙏
I need your help
Thanks sir
Super sir
Column method too ok for me,
2nd column answer repeats in remaining columns.
Please watch the video carefully and use the relevant method as per your needs
7. Array type
At 3:40 you are playing 4x speed, now I'm watching your video in 1.75x speed 🤣 because your video is too long, please try to give below 15 minutes video 🙏
Thanks for your feedback, understood..
I will reduce the timing in future videos
அந்த பின்புல இசையை நிறுத்திட்டு சொல்லித்தர முடியாதா? இரைச்சல் மிக மிக அதிகம். கற்கும் ஆர்வத்தை விட எர்ச்சல்தான் வரும்.
Speed 23:05 fast
Please give the file
You can download the Excel file through this link...
Thanks for your interest!!!
drive.google.com/file/d/1JbTVOhsNWuETuIhA5KZl4u_zGG7eiLxM/view?usp=sharing
View romba kammiya erukku, yaarum education importance kudukkurathu illa pola 🙄, varuttham
Good
Thanks