Make cell A1 = "Holiday" if date in cell B1 matches a date of holidays in a range of cells C1:C25

[dallen8028]

I have searched days to find an answer to this riddle. I've tried Lookup, HLookup, Vlookup, Match, Index with no success.

Make cell A1 = "Holiday" if date in cell B1 matches a date of Holidays in a range of cells C1:C25

Please advise, Thanks in advance.

 

[Tetra201]

Try placing the following formula in cell A1:

=IF(ISNUMBER(MATCH(B1,C1:C25,0)),"Holiday","")

 

[dallen8028]

SWEEEEET! thank again!

 

[dallen8028]

Try placing the following formula in cell A1:

=IF(ISNUMBER(MATCH(B1,C1:C25,0)),"Holiday","")

This worked great until I inserted it into a table. Now it comes back blank like it's not matching. Thoughts?

 

[Tetra201]

The following formula has been tested to work:

=IF(ISNUMBER(MATCH([@Column2],[Column3],0)),"Holiday","")

Providing more details on your table would make helping you easier.

 

[dallen8028]

Providing more details on your table would make helping you easier.

Yes, I agree Tetra201, however:

My Posting Permissions Are

• You may post new threads
• You may post replies
• You may not post attachments
• You may not edit your posts

*I am looking to get a date column in an employee schedule calendar table to auto fill down with the letter H when the corresponding date in row 8 (Not part of the table) matches a "Paid Holidays" table date column on another sheet. The same calendar table cells are also conditionally formatted to match the "Key Code" colors when the appropriate letter that represents Work, Personal, Sick, etc is entered into each cell.

I hope this helps you to understand.

Thank you
Darren