INDEX Function Explained (An Alternative to VLOOKUP) | How to use Excel Index - the right way
In this video explained INDEX formula as an alternative to VLOOKUP in Excel.
The INDEX function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function.
INDEX has 2 different uses:
1) look up a value that is at the intersection of a row and column
2) look up a specific table and then within that specific table look up a value that is at the intersection of a row and column.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
https://drive.google.com/drive/folder...
Playlist Folder-Excel Lookup Functions-IndexExplained.xlsx)
Website - "http://www.innozant.com"
Let's Connect:
Instagram ►Instagram: innozantoffi..
Facebook ► Facebook: innozant
Twitter ► Twitter: innozant
Linkedin ► LinkedIn: inno..
#indexfunction #Innozant #indexmatch #Indexmatchfunctionexcel
The INDEX function will return the value at a given position in a range or array. The INDEX function is often used with the MATCH function.
INDEX has 2 different uses:
1) look up a value that is at the intersection of a row and column
2) look up a specific table and then within that specific table look up a value that is at the intersection of a row and column.
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
https://drive.google.com/drive/folder...
Playlist Folder-Excel Lookup Functions-IndexExplained.xlsx)
Website - "http://www.innozant.com"
Let's Connect:
Instagram ►Instagram: innozantoffi..
Facebook ► Facebook: innozant
Twitter ► Twitter: innozant
Linkedin ► LinkedIn: inno..
#indexfunction #Innozant #indexmatch #Indexmatchfunctionexcel
همه توضیحات ...