Excel - IFERROR Function

0 votes

I'm having some problems with my formula and am hoping you can help.

This is my formula:

=IFERROR(REPLACE(F7, FIND("BOB",A2), 13, "Other"),A2)

I have 3 names in my data (Column B):

  • Bob
  • Sarah
  • Lee

The name "Bob" should be located and returned in column C as "Other," and I also want Sarah and Lee to be returned as Sarah and Lee, respectively. I'm not sure why, but my formula now returns everyone's name as "Open."

Have any suggestions?

Oct 20, 2022 in Others by Kithuzzz
• 38,000 points
400 views

1 answer to this question.

0 votes

Use:

=IF(ISNUMBER(FIND("Bob",A2)),"Other",A2)

![enter image description here

Remember FIND is an exact match while SEARCH does not care about the case.

So if Bob can be BOB and Bob then you may want to use SEARCH.

=IF(ISNUMBER(SEARCH("Bob",A2)),"Other",A2)
answered Oct 20, 2022 by narikkadan
• 63,600 points

Related Questions In Others

0 votes
1 answer

IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
• 63,600 points
3,540 views
0 votes
1 answer

Excel OFFSET function with a dynamic row argument

The answer is to make "anchor cells" ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,128 views
0 votes
1 answer

Equivalent of Excel Round function

Here's a sample LINQPad program that demonstrates one way ...READ MORE

answered Sep 26, 2022 in Others by narikkadan
• 63,600 points
1,081 views
0 votes
1 answer

How to use the INDIRECT function in Excel

Try this: =INDEX(INDIRECT($A$1&"!$1:$1048576"),MATCH($B$1,INDI ...READ MORE

answered Sep 29, 2022 in Others by narikkadan
• 63,600 points
891 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
3,975 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,690 points
1,986 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17, 2022 in Others by Edureka
• 13,690 points
975 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18, 2022 in Others by gaurav
• 23,260 points
3,664 views
0 votes
1 answer

IfError with else, does this function exist in Excel?

Next to IFERROR(), there also is the ISERROR() function, which ...READ MORE

answered Dec 23, 2022 in Others by narikkadan
• 63,600 points
850 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,600 points
3,722 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP