+ Reply to Thread
Results 1 to 2 of 2

Rota Cross Checking

  1. #1
    Registered User
    Join Date
    02-20-2012
    Location
    London, England
    MS-Off Ver
    Excel 2003
    Posts
    1

    Rota Cross Checking

    Hi there, I hope someone can help me as I've become a bit desperate!!

    Im trying to create a rota, which updates a new persons name every wednesday, as the rota changes. So far so good, but I want to create a cross check of our holida roster, so that if the person is on holiday when their name appears, a warning is triggered.

    So far I have a simple lookup which looks up the date and the persons name next to it.

    So our holiday rota looks like this, where the numbers are days of the month, and an H means a holiday.:
    A B C D
    1 NAME 1 2 3
    2 PERSON A
    3 PERSON B H
    4 PERSON C

    So what I want is a formula that says if today is day 2 (col. c) is todays person off on holiday? Therefore, if todays name is person B and today is day 2, are they here??

    I feel like this is very basic formula but I can't get it right!!

    Please help if you can!

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: Rota Cross Checking

    The following formula seems to work

    =INDEX(A1:AF4,MATCH("Person B",A1:A4,0),MATCH(2,A1:AF1,0))
    Martin

+ 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