Excel Formula If Cell Contains Text Then Return Value In Another Cell

One of Excel’s most predominant everyday tasks is checking whether a cell contains a value of interest. In the Excel formula, if a cell contains text, it returns the value in another cell.

If a cell contains text, it returns the value in another cell and checks it by the given formula. Select the output cell, and enter the following formula: =IF(cell=”text”, value_to_return, “”). For eg: the cell we want to check is A3, the text we’re looking for is “example”, and the return value will be Yes.

Several variations of the “If a cell contains” formula in Excel will depend on exactly what values you want to find. Generally, you will use the IF function option to do a logical test and return one value when one of the conditions is met (cell contains) and another matter when the desired condition is not met (cell does not include). The below consists of the most frequent scenarios.

See Also: #Num Error In Excel: Fix It Now And Save Time On Your Spreadsheets!

Ways To Use ‘Excel Formula If Cell Contains Text then Return Value in Another Cell.’

Here are a few ways in which you can fix the issue.

Excel Formula If Column Contains Value 

Let us see how to find cells containing anything, any text, number, or date. For this, we can use a simple formula for non-blank cells.

For example, to return “Not blank” in the desired column B, if column A’s cell in the same row contains any random value, enter the following formula in B2 and double-click the small green icon in the lower-right corner to copy the formula down the column

If the issue excels if the cell contains text, it can rectify another cell’s return value.

See also: Microsoft Excel How To Change Legend Text

Excel Formula If Cell Contains Text

If the column contains values, you want to find only cells with text values, excluding the numbers and dates, and you can use the IF in combination with the ISTEXT function. Here’s the respected formula to return some value in another cell if a target cell contains any text.

For instance, you want to insert the word “yes” in column B if a cell in column A contains the text. To have the work done, the following formula B2.

Excel Formula If Cell Contains A Number 

As referred to in the previous method, you can identify cells with numeric values ( like dates and numbers). For this process, use the IF function together with ISNUMBER.

The respective formula returns “yes” in column B if the respected column A contains any number. Read this article to know how to remove compatibility mode in Excel.

The Excel Formula If Cell Contains Specific Text

Finding the cells containing particular text (numbers or dates) is relatively easy. You write a regular IF Formula, whether a target cell contains the respected text, and type the reader to return in the value_if_true argument.

For instance, to determine if cell A2 contains “apples,” use this desired formula.

=IF(A2= “apples,” “Yes”, “”)

The Excel Formula If Cell Does Not Contain Specific Text

This particular way is opposite to the previous method (i.e.) returns some value to another column if the target cell does not contain the specified text (“apples”). You can do any of the below.

Insert an empty string (“”) in the value_if_arguement, and text to return in the value_if_false argument: 

=IF(A2= “apples”,””, “Not apples”)

Or, you can also put the “not equal to” operator in logical_test and text to return in value_if_true.

=IF(A2<>”apples”, “Not apples”, “”)

And also, the fix for the Excel formula, if a cell contains text, then return value in another cell, can indeed be fixed. 

The Case-Sensitive Formula If Cell Contains Text

To recognize the formula to show the difference between upper and lower case characters, use the EXACT function that checks whether the two text strings are comparatively equal, including the letter case.

=IF(EXACT(A2,”APPLES”), “Yes”, “”)

You can also insert the model text string in some cells ( for instance, in C1), adjust the cell with the $ sign ($C$1), and comparatively, the respected target cell.

Excel Formula for ‘If Cell Contains Text then Return Value In Another Cell.’

Suppose we say we have a list of orders in column A, and you want to find the orders with a respected identifier, say “A.” The desired formula in Excel if cell contains text, then return value will complete the task.

=IF(ISNUMBER(SEARCH(“A-“,A2)),”Valid”,””)

Instead of trying the string in the formula, you can input it in a whole different cell (E1), the respective reference of that cell in your formula.

=IF(ISNUMBER(SEARCH($E$1,A2)),”Valid”,””)

Excel Formula For ‘If The Cell Contains Specific Text, Copy it to Another Column

If the column contains a value, copy the contents of the desired valid cells somewhere else; supply the address of the evaluated cell (A2) in the Value_if_argument.

=IF(ISNUMBER(SEARCH($E$1,A2)),A2,””)

Download: Microsoft Excel

FAQs

How to return a value in another cell if a cell contains certain text in Excel

Excel formula if cell contains text then return value in another cell A1=' My Text To Check' this will ensure the Value of Cell A1 with your respected Text Parameter 2: 'My Text To Return' this is the desired value that you want to return in another Cell if it Matches with Cell A1 Text

How to return a cell value based on another cell value?

You can use the following formula: =IF(A1=B1,C1,' ') Note: Cell A1 and Cell B1 are the two cells that are going to be compared, and Cell C1 is the cell value that you want to extract. =IF(C1=' 70$', B1,' ') C1=' 70$' =IF(C1=' 70$',B1+100,')

Can Excel Return A Value That Is Based On Another Cell?

In the Lookup_value box, search the cell that contains the specific value you will return value based on; In the Column box, specify the column you will return the matched value got from. You can also enter the column number into the textbox itself directly you need.

How Do I Display Specific Text Based On Text In Another Cell?

To display the text that is based on another desired cell, you can also use the conditional function IF. The function represents the value in the first argument ('Bottom 50%'). If the condition is satisfied, it displays the text 'Top 50%.'

How To Automatically Enter The Value Based On Another Cell?

Select a blank empty cell that you want to auto-populate the corresponding value. Copy and paste the formula into it, and now you press the Enter key on your keyboard. From now, whenever you select a name in the drop-down list, E2 will be auto-populated with a specific score.

How Do I Autofill Text In Excel Based On Another Cell?

Based on your description, we can use a simple IF formula to accomplish this. Enter =IF(A2= 'Red,' 'NA,') in D2 and use Autofill to fill cells in column D. However, you motioned that column E also needs to auto-populate based on column A

Conclusion

In conclusion, in this article, the Excel formula if cell contains text, then return value in another cell, If Cell Contains Any Value, and other formulas for Excel have explained it in detail. You can go through any of the methods and rectify your issues.

See Also: {Solved} Fix Not Enough Storage Is Available To Process This Command