Tag Archive: Dynamic function

Articles sur le thème : Dynamic function

Function MATCH – Dynamic VLOOKUP

Presentation of the MATCH function 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. MATCH function needs 3 parameters. The value to find Range of the cells where is the value (1 row or 1 …

Continue reading

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

Dynamic SUM in Excel

Creating a SUM is very easy to do in Excel. But when you want to add only specific cells and not all of them, the formula is not as easy. But it’s possible! Let’s see how to create a dynamic SUM. Insert your data into a Table But before we explain how to create the …

Continue reading

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