INDEX and MATCH
Use of INDEX and MATCH Function /Formula together In Excel
Index: Returns a value or reference of the cell at the intersection of a particular row and column, in a given range.
Match: Returns the relative position of an item in an array that matches a specified value in a specified order
We can use both function together to get our result.
Syntax/Formula of INDEX and MATCH:
The syntax of INDEX and MATCH function in Microsoft Excel is below
=INDEX(array, MATCH(lookup_value, lookup_array, [match_type]), [column_num])
Example OF INDEX and MATCH Function in Excel:
In below example we need Nitin marks in Mathematics subject.
So in this case we use Index and match function together.
Step 1: First you need to create below table in your Excel starting form cell A1 to G11.
Step 2: Type formula =INDEX(C2:F11,MATCH("Nitin",B2:B11,0),2) in cell B15 and press enter.
in Above formula C2:F11 is our array (Marks of all students)
"Nitin" is over lookup_value in match formula
B2:B11 is Students name cell location
0 is for Exact match
2 is Mathematics subject column number.
You can use this formula to find any student marks in any subjects.
 |
| INDEX AND MATCH FUNCTION |
No comments:
Post a Comment