Compare Two Columns in Excel Easily
Find out how to compare columns in Excel and identify missing values or return only missing values with efficient formulas.
VLOOKUP
Discover how to use Excel’s VLOOKUP function with clear, step-by-step guides. Explore easy examples, helpful tips, and practical solutions to quickly find data in your spreadsheets. Save time and reduce mistakes by mastering this essential Excel tool.
How to Use the VLOOKUP Function in Excel
Get a comprehensive understanding of the VLOOKUP function in Excel. Learn how to perform efficient searches in your tables.
Why VLOOKUP Returns #N/A Error
Discover why the VLOOKUP function returns an #N/A error in Excel. Learn the common causes and how to quickly fix VLOOKUP errors.
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.
Search in 2 Columns with VLOOKUP & XLOOKUP
Master the technique of searching in 2 columns in Excel. Say goodbye to the limitations of VLOOKUP and discover the power of XLOOKUP.
Return a Value Between Two Values in a Range
Discover a better way to find a value between two values in Excel. Learn how VLOOKUP and XLOOKUP functions can simplify your search.
Master XLOOKUP function in Excel
Learn how the XLOOKUP function in Excel 365 simplifies data lookup in tables. Find out how it improves VLOOKUP and handles errors better.
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.
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
Anonymize your data
Discover how you can transform your worksheet to anonymise your data in the case you have sensitive data. 5 steps are needed
Categories
- AI & Excel (1)
- Conditional (12)
- Conditional Formatting (18)
- Date (48)
- Dynamic Arrays (10)
- Excel Charts (11)
- Excel Online (4)
- Excel Tests (8)
- Excel Training (15)
- Excel Tutorial (16)
- Expert (26)
- Finance (7)
- Free Excel Tutorial for beginners (29)
- Function (1)
- Intermediate Excel Skills: Tutorials and Articles (19)
- Lookup functions (14)
- Manage data (18)
- Maps and GPS (5)
- Pivot Table (10)
- Power Query (6)
- Quiz Premium (7)
- Shortcuts (5)
- Statistical functions (25)
- Text functions (19)
- Tips and Tricks (21)
VLOOKUP
Compare Two Columns in Excel Easily
How to Use the VLOOKUP Function in Excel
Why VLOOKUP Returns #N/A Error
VLOOKUP Left Lookup Using INDEX or XLOOKUP
Search in 2 Columns with VLOOKUP & XLOOKUP
Return a Value Between Two Values in a Range
Master XLOOKUP function in Excel
Create a Dynamic VLOOKUP function
How to use the INDEX function in Excel?
Create a Lookup Offset
How to use the MATCH function in Excel?
Anonymize your data
