VLookup formula autofill column index number using Columns formula explained in Tamil

Описание: Download the file: http://bit.ly/RnC18012021

தமிழில் விளக்கம் | Excel in Tamil:
Vlookup formulaஐ automaticஆக Column index number மாற எப்படி vlookup formula எழுதுவது?

Description:
VLookup formula autofill column index number using Columns formula explained in Tamil | Excel in Tamil
I have explained how to autofill column index number for a vlookup without manual changes while we are working on dataset that contains multiple columns lookup scenario.

********************************************************************************
Vlookup Excel formula:

How to use VLookup formula with approximate match explained in Tamil | Excel in Tamil
   • How to use VLookup formula with approximat...  

How to use VLookup formula in Excel explained in Tamil | Excel in Tamil
   • How to use VLookup formula in Excel explai...  

VLookup formula with approximate match explained with few more examples in Tamil | Excel in Tamil
   • VLookup formula with approximate match exp...  

********************************************************************************
Basic Excel concepts:

How to use Excel Cell reference explained in tamil| Excel in Tamil | (F4)
   • How to use Excel Cell reference explained ...  

How to create a pivot table in excel Tamil | Excel in Tamil
   • How to create a pivot table in excel Tamil...  

********************************************************************************
Useful Excel shortcuts explained in Tamil

How to select the targeted sheet directly without Ctrl page down page up in excel| Excel in Tamil
   • How to select the targeted sheet directly ...  

How to remove images or objects excel | Excel in Tamil
   • How to remove images or objects excel | Ex...  

Paste values shortcut in excel without copy paste method | Excel in Tamil
   • Paste values shortcut in excel without cop...  

How to navigate within a selected range in an Excel Dataset | Excel in Tamil
   • How to navigate within a selected range in...  

F9 Excel shortcut - An alternative to copy paste special | excel in Tamil
   • F9 Excel shortcut - An alternative to copy...  

Excel shortcut to reach base cell while writing an Excel function | excel in Tamil
   • Excel shortcut to reach base cell while wr...  

Excel shortcut to Remove Time from Date | Excel in Tamil
   • Excel shortcut to Remove Time from Date | ...  

Excel shortcut - how to Convert Text to a Number | Excel in Tamil
   • Excel shortcut - how to Convert Text to a ...  

Excel shortcuts for working with sheet tabs explained in tamil| Excel in Tamil
   • Excel shortcuts for working with sheet tab...  

********************************************************************************
Scenario based formula learning videos Excel in Tamil:

How to fill blank cells in Excel Goto option or Vlookup function excel in Tamil
   • How to fill blank cells using Excel Goto o...  

Excel Vlookup with an inbuilt / independent range explained in Tamil
   • Vlookup with an inbuilt / independent rang...  

Match Function in Excel helps to find duplications in a data range excel in Tamil
   • Match Function in Excel helps to find dupl...  

Aggregate Function in Excel - will produce result with range contains errors/filters excel in Tamil
   • Aggregate Function in Excel - will produce...  

Month Function in Excel - To convert Month name to Number excel in Tamil
   • Month Function in Excel - To convert Month...  

********************************************************************************

Useful Excel options explained in Tamil

How to use Excel view multiple sheets or multiple tabs at once option| Excel in Tamil
   • How to use Excel view multiple sheets or m...  

How to combine cells in Excel without Merge cells option | Excel in Tamil
   • How to combine cells in Excel without Merg...  

How to create a Table in Excel and convert Table to range | Excel in Tamil
   • How to create a Table in Excel and convert...  

Excel Flash Fill menu option explained with examples | Excel in Tamil
   • Excel Flash Fill menu option explained wit...  

How to change Excel comments shapes | Excel in Tamil
   • How to change Excel comments shapes | Exce...  

********************************************************************************

#exceltutorial #excelfunctions #msexcel #msexceltipsandtricks #excelformula #exceltips #excel #advancedexcelformulas #exceltrainingyoutube #advancedexcelskill #basicexceltraining
#exceltipsandtricks #excelintamil #exceltamil

0:00 Recap of previous video about Vlookup formula (Exact match & Approximate match)
0:25 Introduction (VLookup formula autofill column index number using Columns formula)
0:48 Vlookup formula with manual change of column index number
1:39 Challenges of writing vlookup formula by manual change of column index number
2:09 Simple description of Columns function in excel usage
2:55 How to write a VLookup formula by autofill column index number using Columns formula