Ask a question Report Reply to this topic

Search value error [Solved/Closed]

Stu - Aug 11, 2016 at 04:50 AM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen

- Aug 12, 2016 at 10:26 AM

Excel Ask a question Report Reply to this topic

HI,
The value for false refuses to come up as a blank cell in my formula to find and copy a cell if it contains certain initials, or leave it blank if not. It always comes up as an error in the value for the search function. Can anyone spot why and help me correct this?
Kind regards,
Stu

=IF(SEARCH("BP",Sheet1!B4),Sheet1!B3,"")

3 replies

Report Respond to Mazzaropi

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 11, 2016 at 07:10 AM

Helpful

stu, Good morning.

If search_text does not appear in within_text, SEARCH returns the #VALUE! error value.

Try to use it:
=IF(IFERROR(SEARCH("BP",Sheet1!B4),FALSE),Sheet1!B3,"")

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Report

Stu - Aug 12, 2016 at 05:02 AM

Mazzaropi,

Thank you, that has worked perfectly, and in the process I think i can use that to resolve a couple of other formula i had been thiking about but not tried out yet.

Thanks again,

kind regards
Stuart

Report Respond to Mazzaropi

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Aug 12, 2016 at 10:26 AM

Helpful

Stuart, Good morning.

Thanks for the feedback.

Have a nice weekend.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Ask a question