Diabeticus
New Member
- Joined
- Mar 11, 2002
- Messages
- 7
I am using a
=VLOOKUP(D2,Sheet1!A6:B12,2,FALSE)
to look up stuff in another worksheet. i only want to see those values that are not equal to "#N/A"
Is there a way to hide these cells? MAybe using conditional formatting?
Thanks!
=VLOOKUP(D2,Sheet1!A6:B12,2,FALSE)
to look up stuff in another worksheet. i only want to see those values that are not equal to "#N/A"
Is there a way to hide these cells? MAybe using conditional formatting?
Thanks!