IF the date in A1 is a holiday, cell B1 should say "HOLIDAY"

[Pointer]

Here's what I want to do but I'm too dumb to it. Usually I Google
before asking here but my Internet is down though NGs and email work.

PART 1
In cell A1 we enter a date, say, 07/22/04. If the date in A1 is a
holiday I want cell B1 to show the word HOLIDAY. If A1 is not a
holiday, B1 should be blank. I will list the holiday dates in cells D1
to D10.


PART 2
Part 2 is the same as 1 but instead of the word HOLIDAY appearing the
name of the holiday, NEWS YEARS DAY, will appear. I will list the
holiday names in cells E1 to E10 next to the dates in column D.

 

[Frank Kabel]

Hi
part 1:
=IF(ISNUMBER(MATCH(B1,D110,0)),"Holiday","")

part 2:
=IF(ISNUMBER(MATCH(B1,D110,0)),VLOOKUP(B1,D1:E10,2,0),"")

 

[Pointer]

What took you so long?

I'm tied up but will try it today. Thanks for the reply!

 

[Max]

One possibility ..
The delay was because *you* took so long to post the question
Frank's answer was ready, waiting for your post to appear <bg>