Copy cell to new tab from another tab but skip empty cells

[Trislu]

Hi,

Please HELP!

I am trying to create a 2nd tab where it looks for text "OFF" in ColumnB from ColumnA, and copy "Name" in ColumnA to 2nd tab. At the same time, the function skips blank cell.


TAB 1
(ColumnA) (ColumnB)

Name	Amount
Anne	OFF
Amy
Mike
Doe	OFF
Anne	OFF
Mike	OFF
John
Doe	OFF

<tbody>
</tbody>

Ideal Tab2

Name	Amount
Anne	OFF
Doe	OFF
Anne	OFF
Mike	OFF
Doe	OFF

<tbody>
</tbody>

I tried to use IF function, but it doesn't skip blank cell.

 

[Trislu]

Be more specific, I want the 2nd tab only pick up values with "OFF" in column B, the Tab 1 can be

TAB 1
(ColumnA) (ColumnB)

Name	Amount
Anne	OFF
Amy
Mike
Doe	OFF
Anne	OFF
Mike	OFF
John	ON
Doe	OFF

<tbody>
</tbody>

 

[Trislu]

Problem solved.