+ Reply to Thread
Results 1 to 4 of 4

Formula Update to evaluate other columns

  1. #1
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2013
    Posts
    273

    Formula Update to evaluate other columns

    I currently have a look-up that evaluates Column AI. When Column A has a specific value, Column DI is outputting a specific value. If Column A is blank, a “N/A” is output in Column DI. That is working correctly.

    Current formula:
    =IFERROR(VLOOKUP(AI2,Sheet1!N:O,2,FALSE),"N/A")

    However, I need to evaluate two other columns as part of the formula. Some of the values that have a value of “N/A” can be more accurate if I evaluate two other columns.

    How would I update the existing formula to evaluate the other two columns?'

    If Column AI = blank then
    If Column AG2 = “Hello” OR Column AH2 = “Hello1” or Column AH2 = “Hello2” then output a value of “Greeting”
    ELSE
    If Column AG2 = “Bye” OR Column AH2 = “Bye1” or Column AH2 = “Bye2” then output a value of “Later”
    ELSE
    Evaluate the current formula.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,337

    Re: Formula Update to evaluate other columns

    To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    To attach a file to your post,
    click advanced (next to quick post),
    scroll down until you see "manage file",
    click that and select "add files" (top right corner).
    click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

    Once the upload is completed the file name will appear below the input boxes in this window.
    You can then close the window to return to the new post screen.

    However, based on your question...
    =if(AI2="",if(or(AG2 = "Hello",AH2 = "Hello1",AH2 = "Hello2"),"Greeting",If(or(AG2 = "Bye",AH2 = "Bye1", AH2 = "Bye2"),"Later",your-formula)
    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

  3. #3
    Forum Contributor
    Join Date
    03-19-2016
    Location
    Chicago, IL
    MS-Off Ver
    Office 2013
    Posts
    273

    Re: Formula Update to evaluate other columns

    I attached a sample to assist:

    When Column AI (Column C in this example) is present, use the look-up value. When Column AI (Column C in this example) is blank, then evaluate the other two columns:

    If Column AI = blank then
    If Column AG2 (Column A in this example)= “Hello” OR Column AH2 (Column B in this example) = “Hello1” or Column AH2 = “Hello2” then output a value of “Greeting”
    ELSE
    If Column AG2 = “Bye” OR Column AH2 = “Bye1” or Column AH2 = “Bye2” then output a value of “Later”
    Attached Files Attached Files

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, 365 Insiders
    Posts
    10,829

    Re: Formula Update to evaluate other columns

    If I understand correctly in cell D2 and filled down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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