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.
INDEX
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
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.
Function XLOOKUP in Excel
How to use the XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.
Split your text on a delimiter – TEXTSPLIT Function
The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.