INDEX and MATCH reference sheet
|
=INDEX() |
Returns the value of a cell in a table based on the column and row number. =INDEX(B3:B9,4) In the range B3:B9 provide the name of the 4th person.
|
|
=MATCH() |
Returns the position of a cell in a row or column. =MATCH(A5,A3:A9,2)
|
See also:
Free Training Course: Lesson 1 - Excel Fundamentals
See also: Index to Excel VBA Code; Index to Excel Freebies; Lesson 1 - Excel Fundamentals; Index to how to… providing a range of solutions
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Gallery
