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

Closed
Stu - Aug 10, 2016 at 03:58 PM
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,"")