How To Lookup Part of Text in a Cell

MikeLookup Functions, Text Functions3 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