How to use the INDEX function in Excel? Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
VLOOKUP to the left in Excel The function VLOOKUP is not able to return a value on the left of the search column. But you can do the job with XLOOKUP or INDEX MATCH
Create a Lookup Offset When you have many times the same ID in your table, the following formula will help you to create a lookup offset.
Dynamic SUM in Excel 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.
How to use the MATCH function in Excel The MATCH function returns the position of an item in a list. This function is very useful to create DYNAMIC dashboard and formulas
Dynamic VLOOKUP research You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data