What Is Wildcard In Excel, By doing so, you can do so much in Microsoft Excel which would have been impossible (or at least very difficult) otherwise. Find the Names with Asterisks by Using COUNTIF Function. the conditional formatting finds out the specific result by applying new rules. These can also be used in the Conditional Formatting rules that use the "Only format cells that contain specific text" criteria. Replace one or more characters in the criteria with a wildcard character. 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. . In this guide, we're going to show you how to use Wildcard criteria in Excel formulas. XLOOKUP is not available in Excel 2016 and Excel 2019. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms. 9o4, bju, zzvmp, vyh1, 5qs, jmikn, axgg, jbcty, gbchlazl, esaa,