Category Archives: INDEX

No Thumbnail

Excel VLOOKUP vs INDEX and MATCH Speed Comparison

In this article I will be comparing the calculation speed of the function VLOOKUP with that of the INDEX and MATCH combination. For more information about the VLOOKUP function please see the link below: VLOOKUP, Excel Functions For more information about the MATCH INDEX combination please

No Thumbnail

Excel INDEX() Function

In this article I will explain the INDEX() function in Excel. Basically this function receives a range of cells, a row index and a column index as input. It returns the the value or reference of the cell at the specified row and column index.

No Thumbnail

Excel INDEX MATCH Functions

You might have seen a lot of places talking about the INDEX and MATCH functions. The purpose of using the INDEX and MATCH functions together is to create a functionality similar to VLOOKUP. The problem with the VLOOKUP function is that it can only search