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

How To Lookup Part of Text in a Cell

MikeLookup Functions, Text Functions2 Comments

In Excel you may need to lookup just part of the text in a cell. For example, if you have a cell that contains a transaction description and within that description there is a product name.   You want to lookup the price of that product from a table. Let’s look at three possibilities: When the product name is just … Read More