Lookup Question

[Guest]

Cells A1:A5 equal dates (Holidays) these dates will change from year to year.
Cell A6 is todays date.
I need a lookup to go in B6 that will return holiday if A6 is one of the dates listed in A1:A5
Thanks in advance for your help
shebert at scana dot com

 

[Kevin Stecyk]

SteveH,

=IF(ISERROR(MATCH(A6,A1:A5,0)), "no holiday", "holiday")

If A6 is found in A1:A5, then there is no error (false), and there is a
holiday. If it can't be found, there is an error (error), and there is no
holiday.

HTH

Regards,
Kevin