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

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.

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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Pointer" <pointer@nocom.comINVALID> schrieb im Newsbeitrag
news:s1ttf05ge6jnlrrst0076lbrnf22mvnbk0@4ax.com...
> 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.
>

What took you so long?

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


On Thu, 22 Jul 2004 0144 +0200, "Frank Kabel"
<frank.kabel@freenet.de> wrote:

>Hi
>part 1:
>=IF(ISNUMBER(MATCH(B1,D110,0)),"Holiday","")
>
>part 2:
>=IF(ISNUMBER(MATCH(B1,D110,0)),VLOOKUP(B1,D1:E1 0,2,0),"")

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>
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <at>yahoo<dot>com
----
"Pointer" <pointer@nocom.comINVALID> wrote in message
news:ilttf011dgmdcrh353um2cl5il9cbcugjp@4ax.com...
> What took you so long?
>
> I'm tied up but will try it today. Thanks for the reply!