12 Excel Wildcard Examples You Need to Know

MikeLookup FunctionsLeave a Comment

EXCEL WILDCARDS

When you’re looking up text or values you’ll often want to use wildcards in your searches. The wildcards are: * (Asterisk) ? (Question Mark) <> (Less Than, Greater Than)  (blank) Wildcards work with all of the following functions: SUMIF, SUMIFS COUNTIF, COUNTIFS AVERAGEIF, AVERAGEIFS VLOOKUP, HLOOKUP (‘<>’ will not work with these) MATCH (‘<>’ will not work with this) Lets look … Read More