Check if cell entry belongs to a name list-how?
=isnumber(match(a1,sheet2!a:a,0))
My list is in Sheet2, column A (and nothing else is there).
And I'm checking the value in A1 of the activesheet.
Bullman wrote:
Hello
I have only started to use and realise the power of using named lists
to represent a range of values. I am sure it is a simple thing to do,
but what is the easiest logical formula test that will look at a cell
and return a TRUE value if the entry in the cell belongs to a
pre-defined named list and a FALSE value if it does not.
Thanks in advance
Bullman
--
Dave Peterson
|