Link to home
Start Free TrialLog in
Avatar of Kevin Buckland
Kevin BucklandFlag for United States of America

asked on

Formula fix for vlookup and iserror

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
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Kevin Buckland


Works great - way more straightforward than the approach I was using. Thanks!!
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?