![]() ![]() Because the A2 cell does consist of the text “ EXAMPLE ” with the matching case, the formula will return “ Yes ” into the output cell.ĥ.In this scenario, you’d change the formula to =IF(EXACT(A2,"EXAMPLE"), "Yes", ""). For our example, the cell we want to check is A2, the text we’re looking for is “ EXAMPLE ”, and the return value will be Yes.Select the output cell, and use the following formula: =IF(EXACT(cell,"case_sensitive_text"), "value_to_return", "").This version is case-sensitive, meaning that only cells with an exact match will return the specified value. To find a cell that contains specific text, use the formula below. If cell contains specific text, then return a value (case-sensitive) Because the A2 cell does consist of the text “ example ”, the formula will return “ Yes ” into the output cell.Ĥ.In this scenario, you’d change the formula to =IF(A2="example", "Yes", ""). For our example, the cell we want to check is A2, the text we’re looking for is “ example ”, and the return value will be Yes.Select the output cell, and use the following formula: =IF(cell="text", value_to_return, ""). ![]() If cell contains specific text, then return a value
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |