Thanks but it didn't work for some reason. I get FALSE in every instance
even if the data is located in the non-school day column.

"Roger Govier" wrote:

HI
Try
=ISNUMBER(MATCH(C2,L12:L34,0))

--
Regards

Roger Govier


"JICDB" wrote in message
...
I have been searching for over an hour for a solution to my problem.
This
post is the closest to my issue but slightly different. Instead of
showing
True or False I want it to show "Y" or "N".

Example:
I am trying to answer the question is this a school day.
I have a date in cell C2 that I comparing with a list of non-school
days at
I12:I34 (it's one column). If the date matches something in the list
I want
a "N" to appear for NON-School Day. If the date does not match it
must be a
school day so I want to see "Y".

Any help would be greatly appreciated.


"Remote Desktop Connection hotkey" wrote:

Hi!

I function that would search through column of text values (range
with 1
column) and return TRUE if column contains value given as criteria or
FALSE
if there is no such value in given column

For example i have range A1:A10 and i want to find out whether this
range
contains value x or - x