Split your text on a delimiter (TEXTSPLIT) The new TEXTSPLIT function allows you to split the content of your cell on a delimiter. It's very easy to use.
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.
XLOOKUP is a Formula 1 XLOOKUP is the new Excel function to find data in a reference table. The function merge the benefits of VLOOKUP and 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