Search value error

Solved/Closed

Stu - Aug 11, 2016 at 04:50 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Aug 12, 2016 at 10:26 AM

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,"")

This error value refers to a cell that contains a value or blanks
Network error occurred - Guide
Count if cell contains number - Excel Forum
If cell contains date then return value ✓ - Excel Forum
Cmos checksum error - Guide
Excel "IF" function w/ date in test cell ✓ - Excel Forum

2 responses

Answer 1 / 2

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 11, 2016 at 07:10 AM

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

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

Answer 2 / 2

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Aug 12, 2016 at 10:26 AM

Stuart, Good morning.

Thanks for the feedback.

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

Similar discussions

Corel Draw: Error Reading file problem

Excel - IF function with multiple words

If cell = date return yes or no.

If a cell contains any text then add a value

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!