Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

Excel lookup formula puzzler

  • 18-02-2013 12:08PM
    #1
    clint_silver
    Registered Users, Registered Users 2 Posts: 2,915 ✭✭✭


    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: 2,076 ✭✭✭whizbang


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

    IF ID=1 AND DAY=monday


Advertisement
Advertisement