Advanced Excel: Index and Match formula
A very warm welcome to all my viewers in EXCEL4LEARN Channel. Today in this video I cover
What is Index function in excel?
The Excel INDEX function returns the value at a given position in a range or array. You can use index to retrieve individual values or entire rows and columns. INDEX is often used with the MATCH function, where MATCH locates and feeds a position to INDEX.
What is Match Function in excel?
The Microsoft Excel MATCH function searches for a value in an array and returns the relative position of that item.
The MATCH function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the MATCH function can be entered as part of a formula in a cell of a worksheet.
Syntax
The syntax for the MATCH function in Microsoft Excel is:
MATCH( value, array, [match_type] )
The INDEX MATCH function is one of Excel's most powerful features. The older brother of the much-used VLOOKUP, INDEX MATCH allows you to look up values in a table based off of other rows and columns. And, unlike VLOOKUP, it can be used on rows, columns, or both at the same time.
INDEX MATCH is so useful that many Excel pros use it to replace VLOOKUP entirely, never relying on the latter function. It appears frequently in spreadsheets, formulas, and even Excel interviews — so is a great formula to know for business analysts of any tenure.
#EXCEL4LEARN #indexmatch #match #index
YouTube Playlist URL:-
• MS-Excel Tutorial by Akshay
LIKE,SUPPORT and SHARE
PLease press SUBSCRIBE Button and hit the bell icon for notification.
LIke my FB Page:- / excel4learn
Google + :- https://plus.google.com/b/10259595250...
LinkedIn: / akshay-dey-028101138