mcarter973
Board Regular
- Joined
- Mar 24, 2002
- Messages
- 83
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
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