A few words of thanks would be greatly appreciated.

IF Function with SEARCH and ISERROR in Excel

When creating formulas and equations on Microsoft Excel, users have the option of inserting multiple functions and conditions into a formula to attain a desired result. This action is often referred to as nesting. This tutorial will walk you through how to combine the SEARCH, ISERROR and IF functions to scan a document for a particular data piece, and mark it with a particular coding piece in the adjacent column.

How To Use Nestled Functions in Excel

Before beginning, here is a quick run down of the Microsoft Excel functions needed for this to work.

The SEARCH function is used to find a piece of data in an Excel spreadsheet.

The ISERROR function is used to check for error values.

The IF function specifies a condition within the data.

Nestled loops with the IF logical operator can be implemented to seek out a particular word in a column. Together with the ISERROR and SEARCH functions, this formula will allow you to scan a column for a certain word (e.g. "apple") and place a code (e.g. "A") into the adjacent cell each time the word is found.

Combined SEARCH, IF, and ISERROR Function

N.B. The following formula assumes that your data ranges from A1 to A100 (or beyond). If so, the formula should be placed into column B1 and dragged down. You should adjust the column labels depending on the location of your data.

IF(ISERROR(SEARCH("*apple*",A1,1)),"","A ") F(ISERROR(SEARCH("*orange*",A1,1)),IF(ISERROR(SEARCH("*grapes*",A1,1)),"","C"),"B"),"A")

Photo: 123rf.com


A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jean-François Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.
This document, titled « IF Function with SEARCH and ISERROR in Excel », is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
1 Comment