Formula fix for vlookup and iserror

Kevin Buckland
Kevin Buckland used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
You can use below formula in C2 and drag around the columns.
=IF(C$3="","",IFERROR(VLOOKUP(C$3,Holidays!$B:$C,2,0),TEXT(C$3,"DDDD")))
Kevin_Cash_Flow-04-07-17-PM-Day-Loo.xlsm
Kevin BucklandInvestment Officer

Author

Commented:
Works great - way more straightforward than the approach I was using. Thanks!!
ShumsManaging Director/Excel VBA Developer
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

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