Tag Archive: MATCH

Articles sur le thème : MATCH

Function MATCH

The MATCH function returns the position of a value in a range of cells This function is very useful to create dynamic research with the function VLOOKUP or INDEX. Presentation of the MATCH function MATCH function only needs two mandatory parameters and an optional parameter The researched value Reference data (a range of cell) with …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-match/

Function INDEX in Excel

The INDEX function returns the contain of a cell at the intersection of a row and a column in a table or a reference. Presentation of the function INDEX The INDEX function works with three parameters: References of a range of cell containing the value to return The row index The column index [Optional] zone …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/function-index/

Vlookup to the left in Excel

Problem of the VLOOKUP function The normal behavior of the VLOOKUP function is to return data from a table. But you can only return data on the right of the column containing the ID. However, in some cases, you can not change the order of the columns. Like for instance in this document where the …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/vlookup-to-the-left-in-excel/

Create an Offset Vlookup

In the case you have a table that contains the same ID for many - or empty cells. It is strongly recommended to reorder your data To perform this modification, we will use 3 functions , INDEX , MATCH and OFFSET. Problem to solve We have a table (column A:D ) with the list of sales …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/create-an-offset-vlookup/

Dynamic SUM in Excel

Create a SUM is something very easy with Excel. But when you want to add only some specific cells and not all of them, the formula is not so easy but it's possible. Let's see how to create a dynamic SUM.   Insert your data in a Table But before to explain how to create …

Continue reading »

Permanent link to this article: https://www.excel-exercise.com/dynamic-sum-in-excel/