It can be incredibly useful to create a link to VLOOKUP results in Excel®. This is particularly true if you have used VLOOKUP to join data from one table to another. You can jump straight to the result of the VLOOKUP and see the rest of the data in that row of your Excel® table. We can quite easily create … Read More
12 Excel Wildcard Examples You Need to Know
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
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