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
Cash_Flow-04-07-17-PM-Day-Lookup-Te.xlsm
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
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

ASKER

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