Results 1 to 5 of 5

Thread: Excel 2007 - IF function or LOOKUP function

  1. #1
    Seeker dreinisch's Avatar
    Join Date
    Sep 2011
    Location
    Troy, Missouri, United States
    Posts
    9
    Articles
    0

    Excel 2007 - IF function or LOOKUP function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I am trying to create a conditional report. For example....if column E is "D" then what is displayed in column G will be "Account Requiring Adjustment". However, I do not know if the 'IF' function is the way to go or if the 'LOOKUP' function is the way to go. I've tried both, but with no success whatsoever. I am hoping someone may be able to help. The formula's I've created appear as follows:

    IF FUNCTION:
    =IF(E2=D,"Account Requiring Assist Code Adjustment",IF(E2=E,"Adjust Source Code",IF(E2=F,"Adjust LM Counselor",IF(E2=G,"Adjust Plan Type",IF(E2=H,"Email Assigned HOST or Negotiator")))))

    LOOKUP FUNCTION:
    =LOOKUP(E2,{E,E,F,G,H},{"Account Requiring Assist Code Adjustment","Adjust Source Code","Adjust LM Counselor","Adjust Plan Type","Email Assigned HOST or Negotiator"})

  2. #2
    IF FUNCTION:
    =IF(E2="D","Account Requiring Assist Code Adjustment",IF(E2="E","Adjust Source Code",IF(E2="F","Adjust LM Counselor",IF(E2="G","Adjust Plan Type",IF(E2="H","Email Assigned HOST or Negotiator","")))))

    LOOKUP FUNCTION:
    =LOOKUP(E2,{"D","E","F","G","H"},{"Account Requiring Assist Code Adjustment","Adjust Source Code","Adjust LM Counselor","Adjust Plan Type","Email Assigned HOST or Negotiator"})

  3. #3
    Conjurer Simi's Avatar
    Join Date
    Feb 2012
    Location
    Utah, USA
    Posts
    187
    Articles
    0
    I would personally use the IF function, so that you don't end up with #N/A if your check cell E2 is blank.

  4. #4
    Quote Originally Posted by Simi View Post
    I would personally use the IF function, so that you don't end up with #N/A if your check cell E2 is blank.
    But you have to handle that situation, which the OPs formula didn't.

  5. #5
    Seeker dreinisch's Avatar
    Join Date
    Sep 2011
    Location
    Troy, Missouri, United States
    Posts
    9
    Articles
    0
    Hey-Hey! That fixed it! Thank you! Thank you very much!!!!

Tags for this Thread

Posting Permissions

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