Note: In the formula, $C$2:$G$2 is the header range, $C$3:$G$6 is the range contains the specific value in which you will searching for, I3 is the cell contain the criteria value you will match in range $C$3:$G$6, and $C$2 is the first column of range $C$3:$G$6. Please change them to your needs.
return value in another cell if a cell contains certain text in Excel Supposing cell E6 contains value “Yes”, cell F6 will be automatically populated with value “approve”. If you have changed the “Yes” to “No” or “Neutrality” in E6, the value in F6 will be changed to “Deny” or “Reconsider” immediately. How can you do to achieve it? This article collects some useful methods to help you easily solve it.