Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

Search value error [Solved/Closed]

Report
-
Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
 -
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,"")

2 replies

Answer 1 / 2
Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
 143
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

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
Answer 2 / 2
Posts
1928
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 21, 2021
 143
Stuart, Good morning.

Thanks for the feedback.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!