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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel lookup formula puzzler

  • 18-02-2013 11:08am
    #1
    clint_silver
    Registered Users, Registered Users 2 Posts: 2,906 ✭✭✭


    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

  • #2
    whizbang
    Registered Users, Registered Users 2 Posts: 1,974 ✭✭✭whizbang


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

    IF ID=1 AND DAY=monday


Advertisement