You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data
There is 2 methods to create a dynamic SUM in Excel. The first one uses the technique with a Table, the second one uses the function INDEX.
The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
Easily unstack data in Excel with this simple guide. Learn how to quickly rearrange your data for better analysis and visualization.