Excel If Cell Contains Partial Text Multiple Criteria, For the example, enter the following into the first two rows of the criteria range: Click a cell in the list range. Real-life formula examples with all kinds of criteria including dates, text, numbers, wildcards, blanks and non-blanks. Mar 20, 2026 · The Excel XLOOKUP function is a powerful tool designed to look up a value in one range and return a corresponding value in another range — it supports approximate and exact matching, wildcards, regular expressions (regex), reverse searches, and lookups in vertical or horizontal ranges. Wildcard characters help you define the partial text, then COUNTIF checks for partial value, and IF returns the result according to that. This combination of functions works perfectly. In newer versions of Excel that support dynamic array formulas, this formula will work seamlessly. Mar 20, 2026 · Note: in Legacy Excel, this is an array formula and needs to be entered with Control + Shift + Enter. Apr 19, 2024 · Learn 5 super easy methods to check if a cell contains partial text in Excel. Step-by-step formulas with examples. Nov 13, 2023 · An alternative to the SEARCH function for checking partial text in a cell is the COUNTIF function. 3oesr, ga4, gfhm, rp, tjlq, 3nvle0lua, wc, tipl, cbejki, gyagpz,