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

  • Thread starter Thread starter Pointer
  • Start date Start date
P

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.
 
Hi
part 1:
=IF(ISNUMBER(MATCH(B1,D1:D10,0)),"Holiday","")

part 2:
=IF(ISNUMBER(MATCH(B1,D1:D10,0)),VLOOKUP(B1,D1:E10,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>
 
Back
Top