Hi all,
I am having some difficulty with a lookup function to return a true/false value. I have a table of all bank holidays (1 column for 2014 and 1 column for 2015), and I am doing a lookup of a date to the table to see if it is included or not.
Example:
Sept 30, 2014 is FALSE, but am not sure how to get that result. I was using an IF(OR) function to lookup column 2, and then lookup column 3. I was receiving an error.
Bank Holidays 2014 2015
New Year's 1/1/2014 1/1/2015
MLK 1/20/2014 1/19/2015
President's 2/17/2014 2/16/2015
Easter 4/20/2014 4/4/2015
Memorial 5/26/2014 5/25/2015
4th of July 7/4/2014 7/4/2015
Labor Day 9/1/2014 9/7/2015
Columbus Day 10/13/2014 10/12/2015
Veterans' 11/11/2014 11/11/2015
Thanksgiving 11/27/2014 11/26/2015
Christmas 12/25/2014 12/25/2015
Thanks,
Scott
Bookmarks