Employee id has name, department id and particular id. Here we have some employees to look up by the given department Id. Let's understand how to use the function using an example. Note: In The above mentioned formula you can input values like YES/NO or Found/Notfound.Īll of these might be confusing to understand. Use the below formula to get the certain required result format.Ĭase insensitive formula: =IF(ISNUMBER(SEARCH(find_text,within_text)),'value_if_true',value_if_false)Ĭase sensitive formula: =IF(ISNUMBER(FIND(find_text,within_text)),'value_if_true',value_if_false) Use the IF function with formula to return YES or NO. The above formulas will return True or False. Case insensitive means formula looks for AG can return ag, Ag, AG or aG.Ĭase insensitive formula: =ISNUMBER(SEARCH(find_text,within_text)Ĭase sensitive formula: =ISNUMBER(FIND(find_text,within_text) The text you are looking for can either be exact or case insensitive. You are here at the right place to learn How to check if a cell contains specific text. I think you must have thought to do it manually but time constraint. For example finding the department ID from a database. Identify particular text in a cell or different word in given cells. In this article, we will learn How to look up cells having certain text and return the Certain Text in Excel.

Excel search cell containing text