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

Closed
Report
-
The value for false refuse to come up as a blank cell in my formula to find and copy a cell if it contains certain initials. why?

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