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
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