Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: Hide cells that equal a certain value

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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!

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ..Or use:

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

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.



  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 ]

  5. #5
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,060
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    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 ]

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.

  7. #7
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,060
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    8 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •