Let's say there are two columns: A and B each with five rows. Column A has value P03675 in all five rows and Column B has TRUE, TRUE, FALSE, FALSE, TRUE in rows, just like this:

```
A B
P03675 TRUE
P03675 TRUE
P03675 FALSE
P03675 FALSE
P03675 TRUE
```

Column A contains the same value but I need a formula which would look for P03675 and return a result if Column B is FALSE.