Need to check if cell value is equal to a named range (of dates)

[chiidzzz]

Hi, I want to check if the value of certain cells is equal to one of the dates in sheet 2, named "holiday", and then input certain characters in them.
I provided a sample, in which case the code only checks if the cells in sheet 1 are equal to sheet 2, cells A2 and A3; how can I write a better code where it would check all my named range ( "Holiday" in sheet 2)? Thanks

Please Login or Register  to view this content.

[xladept]

A start:

Please Login or Register  to view this content.

[chiidzzz]

Thanks for your reply, it works except for the last cell in "Holiday" range, (A5) "3-Oct". Tuesday 3 must be "-" instead of "o".

[xladept]

Thanks for the rep! Did you want every field checked - what about the "x" & "A"? Working on it now.

[xladept]

Try this:

Please Login or Register  to view this content.

[chiidzzz]

Perfect, thanks again

[xladept]

You're welcome!