How To Use The Index Match At Microsoft Exel Simultaneously? Check The Formula Here

Illustration (freepic)

YOGYAKARTA If you want to improve the ability to process data in Microsoft Excel, one of the formulas that must be mastered is Index and Match. This combination of tools can be used to find and extract values of a range of cells based on certain rows and column positions. So, how to use Index Match at Microsoft Excel simultaneously? To find out, let's look at the explanation below.

Quoted from the Exeljet page, the Index function is used to retrieve values of certain cells based on row and column positions in a table.

Meanwhile, Match functions to find a position in the row or column.

When combined, these two functions become very powerful data search tools, even more flexible than VLOOKUP or HLOOKUP functions.

For example, If you have a sales data table and want to find a number of sales by product name, then Index and Match can do it quickly and accurately.

Here are some excesses of Index and Match functions in Microsoft Excel that you need to know:

After knowing the functions and advantages of the Index Match at Microsoft Excel, now is the time for you to combine these two tools to make it easier to find data.

Here's how to easily use the Index Match at Microsoft Excel:

Formula: =MATCH(lookup_value, lookup_array, [match_type])

Example: =MATCH("Produk A", A2:A10, 0)

This function will look for the position of "Produk A" in column A.

Formula: =INDEX(array, row_num, [column_num])

Example: = INDEX(B2:B10,3)

This function will display the value of the 3rd row in column B.

Formula: = INDEX(B2:B10, MATCH("Produk A", A2:A10, 0)

This formula will look for the position of Produk A in column A, then display the related value in column B.

For example, you have an employee data table containing name and salary. With INDEX and MATCH, you can find out how much Andi pays without having to sort data or use filters. Just enter the combined formula as above, the results will appear automatically.

This is information about how to use the Index Match at Microsoft Excel. Get news updates of other options only on VOI.ID.