VLOOKUP

[mcarter973]

I have data in column A and B

Sheet 1:
Column A Column B
Books 4
Pencils 0
Pens 3

In sheet 2 I want to lookup column b,if NOT zero or blank, grab data from column a and b.
In this example, sheet 2 would display:

Books 4
Pens 3

Thanks

 

[Juan Pablo González]

This is an Advanced Filter, using as criteria ">0" and copy to another range.