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

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/