Formula fix for vlookup and iserror

Kevin Buckland
Kevin Buckland used Ask the Experts™
I'm trying to get a formula that looks up the date in that column and compares it to a list of holidays. If there's a holiday I want it to report the holiday name.  If there isn't a holiday then I just want it to lookup and report the day (e.g., Monday).  

I'm having a problem getting it right when the date is a holiday. For instance, 4/14/17 is a holiday (Good Friday) so I want it to report "Good Friday" but it's reporting FALSE.  I think I don't have enough arguments in the formula for when it doesn't find the current date in the holiday list.  

See example attached, cell P66.

Thank you
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
You can use below formula in C2 and drag around the columns.
Kevin BucklandInvestment Officer


Works great - way more straightforward than the approach I was using. Thanks!!
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Hi Kevin,

If above solution solved your problem, then please close the question.
Here is the link, how to close the question:
How do I close my question?
How do I accept a comment as my solution?

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial