I would like to return all the rows in a column where a certain condition has been met.

So for example, assume this is spreadsheet 'one':

```
 A             B
Jay            Yes
Tim            No
Tom             
Lane           Yes
Luisa          

```

I would like to return the names in spreadsheet one that have the value 'yes' in column B of spreadsheet one, leaving this as my desired out

```
   A           
   Jay         
   Lane        

```

I tried doing this:

```
=IF(One!B:B="Yes"One!A:A)

```

But this returns this

```
A  
Jay
FALSE
FALSE
Lane
FALSE

```