+ Reply to Thread
Results 1 to 9 of 9

uggg N/A Help

  1. #1
    Registered User
    Join Date
    07-11-2013
    Location
    SEATTLE
    MS-Off Ver
    Excel 2010
    Posts
    4

    uggg N/A Help

    I need help getting rid of the 'false' or 'N/A' everything works fine they just annoy me... a lot!

    =IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))

    thank you

  2. #2
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: uggg N/A Help

    Use iferror

    =IFERROR(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

  3. #3
    Registered User
    Join Date
    07-11-2013
    Location
    SEATTLE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: uggg N/A Help

    THANKS! that got rid of the N/a how do i make the false not show up.

  4. #4
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: uggg N/A Help

    I know it's getting bigger, scratching my head for simpler solutions Till i get that, try this

    =IFERROR((IF(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3)))))="FALSE","",(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

  5. #5
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: uggg N/A Help

    Small fix. try this

    =IFERROR((IF(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3)))))=FALSE,"",(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,3),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,3),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,3))))),"")

  6. #6
    Registered User
    Join Date
    07-11-2013
    Location
    SEATTLE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: uggg N/A Help

    This didn't work. no n/a but still false. here is the what is currently work. I just want the cell to be blank when nothing is slected.

    =IFERROR(IF(E8=ULINE,VLOOKUP(B8,AUTOFILL!$E:$G,2),IF(E8=ECONOBOX,VLOOKUP(B8,AUTOFILL!$I:$K,2),IF(E8=ALLIANCE,VLOOKUP(B8,AUTOFILL!$M:$O,2)))),"")

  7. #7
    Forum Contributor
    Join Date
    06-26-2013
    Location
    LAX
    MS-Off Ver
    Excel 2007,Excel 2010
    Posts
    363

    Re: uggg N/A Help

    Hi,

    Please upload a sample excel sheet ( with dummy data if sensitive). It will be easy to sort it out.

  8. #8
    Registered User
    Join Date
    07-11-2013
    Location
    SEATTLE
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: uggg N/A Help

    test box.xlsx

    B8 thru B21 are drop downs that auto fill C&D 8 thru C&D 21 that side works

    E8 has an if statement and now i can't get it to work right

    E8 thru E21 should auto fill F&G 8 thru F&G 21 and that is where the false comes in.

    Also since you are able to do this, J8 thru J21 has $0.00, is thre a way to get rid of that if nothing is filled in as well?

    THANK YOU SO MUCH

  9. #9
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: uggg N/A Help

    test e8 first
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1