Check If Cell Contains Text Case. Use nested functions in a formula to combine the ISNUMBER and SEARCH functions. XLOOKUP E5 code quantityno match2 where code B5B15 and quantity C5C15 are named ranges.
Follow these steps to locate cells containing specific text. In the Find what box enter the textor numbersthat you need to find. Highlight Cells That Contain Specific Text Excel To highlight cells where the cell contains certain text found in another cell we can use a formula in Conditional Formatting.
Use nested functions in a formula to combine the ISNUMBER and SEARCH functions.
IF ISERR VLOOKUP F1A1B212FALSEFalseNot ContainsTrue. As you can see we found all the given department id employees using the above method. On the Home tab in the Editing group click Find Select and then click Find. Finding cells containing certain text or numbers or dates is easy.