Excel Formulas - Lookup Category
Master the Lookup formula in Excel with our easy-to-follow guide. Learn how to search for data across rows or columns, handle approximate matches, and solve common errors to streamline your data analysis today.
Excel Formulas to Lookup Product Price by SKU
Easily look up product prices by SKU in Excel. Learn how to use XLOOKUP and VLOOKUP formulas to find pricing data instantly with this quick guide.
How to Look Up Employee Records in Excel by ID Number
Learn how to easily retrieve complete employee records in Excel using their ID number with step-by-step formulas like XLOOKUP and VLOOKUP.
How to Return Multiple Lookup Values in Excel Using the FILTER Function
Learn how to use Excel's FILTER function to lookup and return multiple matching values with this simple, step-by-step formula guide.
Excel Formulas for Finding the Closest Approximate Match
Learn how to find the closest match in Excel using approximate search formulas like XLOOKUP, VLOOKUP, and INDEX/MATCH.
Excel Two-Way Lookup: How to Find Matrix Data Using Row and Column Headers
Learn how to perform a two-way matrix lookup in Excel using INDEX/MATCH or XLOOKUP to easily find values at the intersection of row and column headers.
Excel Formula to Find the Nth Occurrence Using SMALL and ROW
Master the Excel formula to lookup the Nth occurrence of a value using INDEX, SMALL, and ROW. Easily find the 2nd, 3rd, or any match in your dataset.
How to Look Up the Latest Date in Excel Using MAX and FILTER
Learn how to combine Excel's MAX and FILTER functions to easily lookup and return the latest date based on your specific criteria.
Mastering Excel Lookup Formulas for Partial Text and Wildcards
Learn how to use Excel formulas like XLOOKUP and VLOOKUP with wildcard characters to easily search and retrieve data based on partial text matches.
Excel LOOKUP Formula to Find the Last Non-Blank Cell in a Row or Column
Master the Excel LOOKUP formula to quickly find and retrieve the last non-blank cell in any row, column, or lookup vector with this easy guide.
Dynamic Image Lookup in Excel Using Formulas and Cell References
Learn how to dynamically look up and display image files in Excel using cell references and formulas like the IMAGE and XLOOKUP functions.
Dynamic Multi-Sheet Excel Lookups Using the INDIRECT Function
Learn how to combine Excel lookup formulas with the INDIRECT function to dynamically search and retrieve data across multiple worksheets.
Excel Formulas to Look Up Rows with Multiple Criteria
Learn how to look up a target row in Excel using multiple criteria with easy-to-follow XLOOKUP and INDEX MATCH formulas.
Excel Lookup Formulas for Tiered Commission Rates and Sales Targets
Learn how to use Excel formulas like XLOOKUP or VLOOKUP to easily look up sales targets and calculate tiered commission rates accurately.
How to Use Regular Expressions for Advanced Text Lookups in Excel
Learn how to lookup text strings in Excel using Regular Expressions (Regex). Master pattern matching with XLOOKUP and Excel's new native REGEX functions.
Excel Formulas to Lookup Price by Product ID: VLOOKUP and XLOOKUP Guide
Learn how to quickly look up product prices in Excel using VLOOKUP or XLOOKUP formulas based on a Product ID with easy step-by-step examples.
Excel Formulas to Look Up Email Addresses by Name
Easily retrieve email addresses from names in Excel using simple XLOOKUP and VLOOKUP formulas with this quick, step-by-step guide.
How to Perform a Left Lookup in Excel Using INDEX MATCH and XLOOKUP
Learn how to look up values to the left in Excel using XLOOKUP or INDEX MATCH with this easy, step-by-step guide to mastering the left lookup formula.
Excel Formulas to Find the Last Row with Data
Learn how to find the last row with data in Excel using powerful formulas like LOOKUP, MATCH, and XLOOKUP to dynamically reference your ranges.
Excel Formulas to Lookup and Return Multiple Matching Values
Learn how to lookup a value and return multiple matching results in Excel using the FILTER function and advanced array formulas in this step-by-step guide.
How to Perform a Case-Sensitive Lookup in Excel
Learn how to perform a case-sensitive lookup in Excel using the EXACT function combined with XLOOKUP or INDEX and MATCH for precise data matching.
How to Look Up and Display Images in Excel Based on Cell Value
Learn how to dynamically lookup and display images in Excel based on cell values using formulas like XLOOKUP and INDEX/MATCH.
Lookup Values Based on Cell Fill Color in Excel
Learn how to easily lookup and retrieve values in Excel based on cell fill color using a simple custom VBA function.
Excel Two-Way Lookup: How to Find the Intersection of Row and Column Headers
Learn how to easily find the intersection of row and column headers in Excel using a two-way lookup with INDEX, MATCH, or XLOOKUP.
Excel Formulas to Lookup and Sum Matching Values
Learn how to easily look up a value and sum all corresponding matches in Excel using powerful formulas like SUMIF, SUMIFS, and SUMPRODUCT.
How to Find the First Non-Blank Cell in an Excel Row
Learn how to find and lookup the first non-blank cell in an Excel row using simple formulas like INDEX, MATCH, and XLOOKUP.