Search column for value and return TRUE or FALSE
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 (its 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
|