In this article we will learn how to specified number, if a cell contains certain text. We will use the combination of IF, ISNUMBER and SEARCH functions in Microsoft Excel.
Let’s understand with a simple exercise how we can specify the text in a cell based on the text in another cell. We have 2 numbers in the range A2:A4. Now we want to specify the text in range B2:B3.
SEARCH function will search the number in cell, if the searched number will be in cell then function will return numeric value else #VALUE! Error.
On the basis of Search function’s result ISNUMBER function will give the result in TRUE or FALSE.
IF function will check the logical test is true then result is set, in condition of FALSE will check for another value.
This is the method you can follow if you want to put specified text with a number in one cell based on the data in another cell.
For more example, click here
If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at firstname.lastname@example.org
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.