Learn how to use the INDEX function in Excel. Step-by-step guide for beginners and experts to improve your data analysis skills.
You can replace the third argument of your VLOOKUP function with a MATCH function to create a dynamic formula to research your data
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
When you have many times the same ID in your table, the following formula will help you to create a lookup offset.
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 XLOOKUP function of Excel? It's a combination of the VLOOKUP and INDEX functions. Look at this article.
The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.