VLOOKUP Left Lookup Using INDEX or XLOOKUP
Explore advanced Excel techniques to overcome VLOOKUP limitations and retrieve data from the left with XLOOKUP or INDEX/MATCH.
MATCH
Create a Dynamic VLOOKUP function
Learn how to create a dynamic VLOOKUP with the MATCH function and customize your search criteria to return accurate results in Excel.
Dynamic SUM in Excel
Discover two powerful techniques for creating dynamic sums in Excel: Excel Tables and the SUM function with INDEX.
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.
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.
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
Categories
- Conditional (11)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (15)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (20)
- Lookup functions (14)
- Manage data (20)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (5)
- Shortcuts (5)
- Statistical functions (23)
- Text functions (17)
- Tips and Tricks (21)
