"IF" and "SEARCH" - not able to get the else part of the logic to show value

[noname91]

Hi all,

Simple issue - I'm using the following formula:

=IF(SEARCH($A$1,B1), 1,0)

to check if a cell contains a specific string called "[OPEN]", and if so, mark an adjacent cell as 1, else 0. I'm also anchoring the cell that contains the text to search [OPEN] so I don't have copy this down for all cells in the column. I'm able to get the 1 to show for cases where the cell contains [OPEN], but get #VALUE! for those cells which don't. Is there anything I can do to fix this?

I've attached a workbook.

Thanks.

[JohnTopley]

Try

=IFERROR(IF(SEARCH($A$1,B2), 1,0),0)

[noname91]

Thanks JohnTopley! Works nicely.