Excel Functions & Formulas
How to Use VLOOKUP with Two Lookup Values in Excel
Master using VLOOKUP with two lookup values in Excel by applying helper columns, the CHOOSE function, or nested formulas for precise results.
Read article
Vlookup
17 lessons in order
Excel Functions & Formulas
Vlookup from Multiple Columns with Only One Return in Excel
Learn how to VLOOKUP from multiple columns in Excel with one return using a helper column, XLOOKUP, or the INDEX-MATCH formula.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Auto-Transfer Data Between Excel Sheets
Learn how to transfer data between Excel worksheets automatically using VLOOKUP, XLOOKUP, or INDEX-MATCH for flexible and accurate lookups.
Read article
Excel Functions & Formulas
How to Use VLOOKUP with Date Range in Excel (3 Examples)
Learn how to use VLOOKUP with date ranges in Excel, plus INDEX-MATCH and LOOKUP methods to return values when dates fall between ranges.
Read article
Excel Functions & Formulas
Excel VLOOKUP to Find a Value That Falls Between a Range
Learn how to use VLOOKUP and alternative Excel functions to find values that fall between a range for accurate data analysis.
Read article
Excel Functions & Formulas
How to Combine VLOOKUP with COUNTIF in Excel (2 Examples)
Learn how to combine VLOOKUP with COUNTIF in Excel to count occurrences accurately using absolute references for better results.
Read article
Excel Functions & Formulas
How to Vlookup to Return All Matches in Excel (4 Suitable Ways)
Learn how to use VLOOKUP in Excel to return all matches, with methods like FILTER, Advanced Filter, and Power Query tools.
Read article
Excel Functions & Formulas
How to Vlookup and Return Second Match in Excel (2 Easy Ways)
Learn how to VLOOKUP the second match value in Excel with or without a helper column using advanced formulas like INDEX, SMALL, and FILTER.
Read article
Excel Functions & Formulas
How to Vlookup with Multiple Criteria in Different Excel Sheets
Learn how to VLOOKUP with multiple criteria across different Excel sheets using INDEX-MATCH, XLOOKUP, and FILTER functions.
Read article
Excel Functions & Formulas
How to Vlookup Multiple Values in One Cell in Excel (5 Examples)
Learn how to VLOOKUP multiple values in one cell using TEXTJOIN, FILTER, UNIQUE, and VBA codes—both with and without duplicates.
Read article
Excel Functions & Formulas
How to Perform Case-Sensitive Vlookup in Excel (4 Examples)
Learn 4 effective ways to perform case-sensitive VLOOKUP in Excel using CHOOSE, EXACT, XLOOKUP, SUMPRODUCT, and INDEX-MATCH functions.
Read article
Excel Functions & Formulas
How to Use VLOOKUP with CHOOSE Function in Excel
Learn how to use the VLOOKUP with CHOOSE function in Excel to handle single, multiple, and complex lookup criteria efficiently.
Read article
Excel Functions & Formulas
Excel LOOKUP vs VLOOKUP: Key Differences Explained
Learn the key differences between Excel LOOKUP and VLOOKUP functions, including how to use each for efficient data searches.
Read article
Excel Functions & Formulas
How to Use Nested VLOOKUP in Excel (2 Examples)
Learn how to use nested VLOOKUP in Excel to find sales values by product and return product details by salesman easily.
Read article
Excel Functions & Formulas
How to Use VLOOKUP to Find the Closest Match in Excel
Learn how to use VLOOKUP in Excel to find the closest approximate or partial text match with step-by-step examples and tips.
Read article
Excel Functions & Formulas
How to Apply Dynamic VLOOKUP Formula in Excel
Learn how to use a dynamic VLOOKUP in Excel with MATCH, dynamic column references, and COLUMNS function for flexible lookups.
Read article
Excel Functions & Formulas
How to Remove Vlookup Formula and Keep Values in Excel
Learn how to remove VLOOKUP formulas in Excel and keep values using paste special, shortcuts, and drag and drop methods.
Read article