Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel lookup formula puzzler

Options
  • 18-02-2013 12:08pm
    #1
    clint_silver
    Registered Users Posts: 2,900 ✭✭✭


    we all love a good excel puzzler, I cant seem to get this one....

    simplified data example: 3 columns

    ID DAY STATUS
    1 monday complete
    1 sunday incomplete
    2 monday complete
    3 sunday incomplete
    3 sunday complete



    I want the status for a given ID and DAY
    So in my formula cell I want something that will
    = lookup ID column
    IF ID=1
    lookup DAY column,
    IF DAY=monday
    return status


Comments

  • Options
    #2
    whizbang
    Registered Users Posts: 1,931 ✭✭✭whizbang


    use AND. lookup all at once rather than using criteria.

    IF ID=1 AND DAY=monday


Advertisement