Hi

It returns True or False for me depending upon whether the date is the
list or not.
Are you using proper Excel dates, or are they Text representations of
the date.
If you type =C2+1 and format the cell as date, do you get a date which
is one day greater than the date in C2?
similarly, what happens if you add 1 to each of the date values in
L12:L34.

To return what you are looking for in terms of "Y or "N" than the
formula needs to be
=IF(ISNUMBER(MATCH(C2,L12:L34,0)),"N","Y")

--
Regards

Roger Govier


"JICDB" wrote in message
...
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