Output comes up with #VALUE! when I use OR() and SEARCH()

I want two worksheets where on Sheet2 the cell D19 is referencing cells from Sheet1 if they contain "RB". Here is the formula I put down but it doesn't work as it is only returning #VALUE!.

Formula:

Please Login or Register  to view this content.

When I have it where it only searches specifically for "RB" but nothing else, it works fine:

Formula:

Please Login or Register  to view this content.

. However this isn't what I want because there are some cells that contain RB along with other text.

I appreciate any with with the solution. Thanks!

Perfect! That worked. Thank you! What do the *'s mean in the COUNTIF() statement?

Also, do you know if there is then a way I can get it so that the following entries then line up consecutively? Here is what happens currently:

Please Login or Register  to view this content.

It is copying from the table in Sheet1 but has all the spaces that don't qualify as empty. How could I do it so that they would go to the next row?
I would also like it to then add future entries automatically if that is possible.

I imagine that it could work something like I have to test if the cell = 0. If it does not equal 0 then test the next cell down. If it does equal 0 then put the text in there. However I'm not sure how to do that or if that is even correct.