We help IT Professionals succeed at work.

Formula fix for vlookup and iserror

192 Views
Last Modified: 2018-02-02
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
Cash_Flow-04-07-17-PM-Day-Lookup-Te.xlsm
Comment
Watch Question

Managing Director/Excel VBA Developer
CERTIFIED EXPERT
Distinguished Expert 2018
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION

Author

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

Commented:
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?
Thanks