| How to use Index and Match Function in Excel | by Let's Learn Excel
What Does It Do ?
This function picks a value from a range of data by looking down a specified number
of rows and then across a specified number of columns.
It can be used with a single block of data, or non-continuos blocks.
Syntax
There are various forms of syntax for this function.
Syntax 1
=INDEX(RangeToLookIn,Coordinate)
This is used when the RangeToLookIn is either a single column or row.
The Co-ordinate indicates how far down or across to look when picking the data from the range.
Both of the examples below use the same syntax, but the Co-ordinate refers to a row when
the range is vertical and a column when the range is horizontal.
My Excel Channel Link
/ @letslearnexcel6536
My other Channel Link
/ @debasishdebnath
To see all my previous videos,click on the link
• All About Excel
To download the excel file,click on the link below
https://drive.google.com/open?id=1VBZ...
Facebook: / debasish.debnath.5201
Twitter : / deba007007
Email :[email protected]