Index() & Match() function in Excel | Fun with MS Excel
#indexmatch #matchfunctioninExcel #indexfunctioninExcel
In this video, I have explained #INDEX and #MATCH functions in MS Excel.
INDEX() is a very important function in Excel which we can use to find the value of a cell in a given table based on the its row and column numbers.
MATCH() function in Excel is used to find the position of a cell in a table vis-à-vis its row and column.
/ @funwithmsexcel935
• Highlight due date, make text invisible, s...
• Easiest way to create salary slip in Excel
• Hlookup in Excel (with IFERROR)