+ Reply to Thread
Results 1 to 9 of 9

Help with Iferror(vlookup( formula ASAP

  1. 08-13-2013, 03:15 PM #1
    rwmeis
    rwmeis is offline
    Registered User
    Join Date
    08-13-2013
    Location
    My House, AL.
    MS-Off Ver
    Excel 2010
    Posts
    39

    Help with Iferror(vlookup( formula ASAP

    Thank you to anyone in advance. The formula below is driving me crazy. I think it is the parenthesis.

    The logic is: vlookup #1.....if error,vlookup #2......if error, vlookup #3......if error, "not coded"

    =if(iferror(vlookup(B2,'HDM- Charts Coded Not Released '!$L:$M,2,false)),(if(iferror(vlookup('OBER Data'!B2,'HDM- Charts Coded Released'!$L:$M,2,false)),(iferror(vlookup('OBER Data'!B2,'KG REASON for Hold Outpat'!$F:$G,2,false)),"Not Coded"),(vlookup('OBER Data'!B2,'KG REASON for Hold Outpat'!$F:$G,2,false))),(vlookup('OBER Data'!B2,'HDM- Charts Coded Released'!$L:$M,2,false))),(vlookup(B2,'HDM- Charts Coded Not Released '!$L:$M,2,false)))
    Reply With QuoteRegister To Reply
  2. 08-13-2013, 03:17 PM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Help with Iferror(vlookup( formula ASAP

    Your profile says 2003, but iferror is not available in 2003? Please check, and if necessary, update your profile
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  3. 08-13-2013, 03:19 PM #3
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Help with Iferror(vlookup( formula ASAP

    If you are using IFERROR it seems you have a latter version than 2003. In that case use

    =IFERROR(VLOOKUP(B2,'HDM- Charts Coded Not Released '!$L$1:$M$65536,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'HDM- Charts Coded Released'!$L$1:$M$65536,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'KG REASON for Hold Outpat'!$F$1:$G$65536,2,FALSE),"Not Coded")))
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  4. 08-13-2013, 03:19 PM #4
    rwmeis
    rwmeis is offline
    Registered User
    Join Date
    08-13-2013
    Location
    My House, AL.
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Help with Iferror(vlookup( formula ASAP

    Really?....your worried about my profile?
    Reply With QuoteRegister To Reply
  5. 08-13-2013, 03:23 PM #5
    Craig K.
    Craig K. is offline
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: Help with Iferror(vlookup( formula ASAP

    Try this
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    Edit: Oops, looks like Ace beat me to it.
    Edit 2: The profile does matter because functionality is different between 2003 and 2007. Some functions that work in '07 will NOT work in '03.
    Last edited by Craig K.; 08-13-2013 at 03:25 PM. Reason: Someone beat me to it.
    Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.

    Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
    If you're happy with an answer given, please click the * under the person's name to boost their reputation.
    Reply With QuoteRegister To Reply
  6. 08-13-2013, 03:25 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,939

    Re: Help with Iferror(vlookup( formula ASAP

    rwmeis, the reason for my request is so that members can tailor suggestions based on the version you are using

    =IFERROR(VLOOKUP(B2,'HDM- Charts Coded Not Released '!$L:$M,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'HDM- Charts Coded Released'!$L:$M,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'KG REASON for Hold Outpat'!$F:$G,2,false),"Not Coded")))

    is a LOT different to...
    =if(iferror(vlookup(B2,'HDM- Charts Coded Not Released '!$L:$M,2,false)),(if(iferror(vlookup('OBER Data'!B2,'HDM- Charts Coded Released'!$L:$M,2,false)),(iferror(vlookup('OBER Data'!B2,'KG REASON for Hold Outpat'!$F:$G,2,false)),"Not Coded"),(vlookup('OBER Data'!B2,'KG REASON for Hold Outpat'!$F:$G,2,false))),(vlookup('OBER Data'!B2,'HDM- Charts Coded Released'!$L:$M,2,false))),(vlookup(B2,'HDM- Charts Coded Not Released '!$L:$M,2,false)))
    Reply With QuoteRegister To Reply
  7. 08-13-2013, 03:57 PM #7
    rwmeis
    rwmeis is offline
    Registered User
    Join Date
    08-13-2013
    Location
    My House, AL.
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Help with Iferror(vlookup( formula ASAP

    I understand....Thank you everyone for the help
    Reply With QuoteRegister To Reply
  8. 08-20-2013, 03:29 PM #8
    rwmeis
    rwmeis is offline
    Registered User
    Join Date
    08-13-2013
    Location
    My House, AL.
    MS-Off Ver
    Excel 2010
    Posts
    39

    Re: Help with Iferror(vlookup( formula ASAP

    Okay I need to add one more vlookup to this formula.

    =IFERROR(VLOOKUP(B2,'HDM- Charts Coded Not Released '!$L$1:$M$65536,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'HDM- Charts Coded Released'!$L$1:$M$65536,2,FALSE),IFERROR(VLOOKUP('OBER Data'!B2,'KG REASON for Hold Outpat'!$F$1:$G$65536,2,FALSE),"Not Coded")))

    Vlookup1...if error
    Vlookup2...if error
    vlookup3...if error
    vlookup4...if error
    if error = not coded
    Reply With QuoteRegister To Reply
  9. 08-20-2013, 03:52 PM #9
    Craig K.
    Craig K. is offline
    Valued Forum Contributor
    Join Date
    10-10-2012
    Location
    New York
    MS-Off Ver
    Excel 2007/2010
    Posts
    337

    Re: Help with Iferror(vlookup( formula ASAP

    Replace the red text with the vlookup you want to add.

    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Long formula using IFERROR and VLOOKUP returning #NAME?
    By redimp in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-04-2013, 09:08 AM
  2. [SOLVED] Using VLOOKUP and CONCATENATE within an IFERROR formula
    By mowens74 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2013, 12:24 PM
  3. [SOLVED] Iferror vlookup
    By chris.slater in forum Excel General
    Replies: 2
    Last Post: 04-20-2012, 03:37 AM
  4. I need Vlookup help ASAP!
    By bassboy in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-28-2007, 11:28 PM
  5. [SOLVED] Vlookup Help needed ASAP
    By Vladimir in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-15-2005, 05:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1