Excel Formulas - Search Category
Master the art of locating data with our guide to every essential search Excel formula. Learn how to use VLOOKUP, XLOOKUP, and INDEX MATCH to find information instantly and streamline your spreadsheets for maximum efficiency.
Excel XLOOKUP Formula for Specific and Partial Text Search
Learn how to use Excel's XLOOKUP formula to search for specific or partial text using wildcards in this quick, step-by-step guide.
Excel INDEX and MATCH Formula for Multiple Criteria Lookup
Master the Excel INDEX and MATCH formula to search and look up data using multiple criteria with this step-by-step tutorial and practical examples.
How to Use HLOOKUP to Search Values in Excel Tables
Learn how to use the Excel HLOOKUP formula to quickly search for a value in the top row of a table and retrieve matching data from a specific row.
How to Search Dynamic Arrays in Excel with the FILTER Function
Learn how to use the Excel FILTER function to search dynamic arrays and quickly extract matching data based on single or multiple criteria.
Mastering Case-Sensitive Excel Lookups with INDEX, MATCH, and EXACT
Learn how to perform a case-sensitive search in Excel by combining the EXACT function with INDEX MATCH for precise, case-specific text lookups.
Finding the Nth Occurrence in Excel Using INDEX and SMALL Formulas
Learn how to use Excel's INDEX and SMALL functions to find and extract the Nth occurrence of a lookup value with this step-by-step formula guide.
Finding the Closest Value in Excel Using ABS and MIN Formulas
Learn how to find the closest or nearest number in Excel using a powerful formula with the MIN and ABS functions. Step-by-step guide with examples.
Excel VLOOKUP Across Multiple Worksheets with the INDIRECT Function
Learn how to use VLOOKUP and INDIRECT in Excel to search and retrieve data across multiple worksheets with this step-by-step formula guide.
Creating a Custom Excel Fuzzy Match Search Formula with VBA
Master fuzzy matching in Excel: Learn how to create a custom VBA formula to search and find approximate text matches in your spreadsheets.
Using Excel SUMPRODUCT to Search and Sum Date Ranges
Learn how to use the Excel SUMPRODUCT formula to search, filter, and sum data within specific date ranges with this easy, step-by-step guide.
Excel Formulas for Searching Values with Multiple Criteria
Learn how to search and look up values in Excel using multiple criteria with easy-to-use formulas like XLOOKUP, INDEX MATCH, and FILTER.
Excel Formulas for Substring Search and Wildcard Matching
Learn how to use Excel formulas like SEARCH and COUNTIF with wildcards (* and ?) to easily find and match substrings in your spreadsheets.
Excel Formulas to Find the Last Occurrence in a Row
Learn how to find the last occurrence of a value in an Excel row using simple formulas like XLOOKUP and LOOKUP with this step-by-step guide.
How to Search Across Multiple Worksheets in Excel Using Formulas
Learn how to write Excel formulas to search across multiple worksheets and quickly find data using VLOOKUP, INDEX MATCH, or VSTACK.
Excel Formulas for Fuzzy Text Search and Matching in Datasets
Learn how to write Excel formulas to perform fuzzy text searches and find approximate matches in your dataset easily.
Excel Formulas to Search and Retrieve Values from Merged Cells
Discover how to write Excel formulas to search and look up values in merged cells, overcoming standard lookup limitations and errors instantly.
Excel Formula to Find the Closest Value Without Exceeding a Limit
Learn how to find the closest number in Excel without exceeding your limit using step-by-step formulas like XLOOKUP and INDEX/MATCH.
Excel Regex Formulas: Searching and Matching Patterns in Cells
Learn how to use Excel's new REGEX formulas to search, match, and extract complex text patterns in your spreadsheet cells easily.
Excel Formulas to Search and Identify Duplicate Rows in a Database
Easily find and identify duplicate rows in your Excel database using powerful formulas like COUNTIFS and UNIQUE to clean your data instantly.
How to Perform a Two-Way Lookup in Excel Using INDEX and MATCH
Learn how to use the Excel INDEX MATCH formula for a two-way lookup to easily find values at the intersection of any row and column.
Excel Formula to Search and Extract Image Alt Text in Grids
Learn how to search, extract, and find image alt text within an Excel grid using formulas, the IMAGE function, or simple VBA workarounds.