Hide cells that equal a certain value

[Diabeticus]

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!

 

[Dave Hawley]

..Or use:

=IF(COUNTIF(A1:B16,D2)=0,"",VLOOKUP(D2,Sheet1!A6:B12,2,FALSE))

 

[Diabeticus]

Hmmm.

I don't think that is exactly what I was looking for. thanks for the suggestion. It's still displaying "#N/A" when it doesn't find something that meets my criteria. These cells are what are showing up.

I basically want to hide the entire ROW if a value of #N/A is returned. I think it is proabably beyind the scope of excel, though I could be wrong.

 

[Chris Davison]

how about auto filter on anything that does not equal "#N/A" ?

_________________
Hope this helps,
Chris

This message was edited by Chris Davison on 2002-03-12 15:16
This message was edited by Chris Davison on 2002-03-12 15:16

 

[Aladin Akyurek]

On 2002-03-12 09:46, Diabeticus wrote:
Hmmm.

I don't think that is exactly what I was looking for. thanks for the suggestion. It's still displaying "#N/A" when it doesn't find something that meets my criteria. These cells are what are showing up.

I basically want to hide the entire ROW if a value of #N/A is returned. I think it is proabably beyind the scope of excel, though I could be wrong.

Just curious about how you get #N/A when you use:

=IF(COUNTIF(A6:A12,D2),VLOOKUP(D2,Sheet1!A6:B12,2,0),"")

where 0 as the 4th arg of VLOOKUP is the same as FALSE?
This message was edited by Aladin Akyurek on 2002-03-12 15:29

 

[Diabeticus]

I don't know Aladin. It just did. Either way, it didn't help me with my original problem. I wish I knew why #N/A was showing up.

It is possible I implemented teh formual incorrectly. Who knows. Incidentally, I am looking into the AutoFilter possibility....looks like I may need to use a "Pivot Table" whatever that is. Reading HELP THOGUH! thanks.

 

[Aladin Akyurek]

On 2002-03-13 13:39, Diabeticus wrote:
I don't know Aladin. It just did. Either way, it didn't help me with my original problem. I wish I knew why #N/A was showing up.

It is possible I implemented teh formual incorrectly. Who knows. Incidentally, I am looking into the AutoFilter possibility....looks like I may need to use a "Pivot Table" whatever that is. Reading HELP THOGUH! thanks.

You still get #N/A's. Hmmm. Maybe the lookup table itself has #N/A's? I'd like too see that WB.

Aladin