INDEX AND MATCH IN EXCEL.

INDEX
This excels index function returns a value of a cell in a particular table. You can use index to retrieve individual values or entire rows and columns.

Formula: index (array, row_num, [column-num])

Formula: index(array, row_num, [column-num])

HOW TO USE THE INDEX FORMULA
Example: Above is a brief salary representation of some workers for a period of four months (Jan-April). The accountant decides to use Index Function to look for the salary of Babatunde in the month of February as thus:
STEPS
Type “=INDEX (” and select the area of the table B2:F7, then add a comma
Type the row for Babatunde, which is “4”, then add a comma
Type the column number for February which is “2”, and close the bracket
The result is 17000

MATCH
This excel function returns the position of a particular value of a cell in a row or column
Formula: “=MATCH (lookup_value, lookup_array, [match-type])”

HOW TO USE THE MATCH FORMULA
Example: Using the same table above, the accountant decides to use Match Function to look for the position of Babatunde in the month of February as thus:
STEPS
Type “=MATCH (” and select the area of the table C5 then add a comma
Select the range C2:C7 on the column C then add a comma
Type the match type zero “0” for an exact match
Then close the bracket
The result is that Babatunde salary for February is in the row “4”.

INDEX-MATCH FUNCTION IN EXCEL
The index Match formula is the combination of two functions in Excel: INDEX and MATCH

= INDEX() returns the value of a cell in a row or column.

=MATCH() returns the position of a cell or column

Combined, the two formulas can look up and return the value of a cell in a table based on vertical and horizontal criteria.

HOW TO COMBINE INDEX AND MATCH
=INDEX(array, MATCH(lookup_value, lookup_array, [match_type])

Using the same example above, determine the February salary for Client Ajoba.

See https://corporatefinanceinstitute.com/resources/excel/study/index-match-formula-excel/

Leave a Reply

Your email address will not be published.