=--ISNUMBER(MATCH(B8;TestRange;0))

should work

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Memento" wrote in message
...
Hello Guys and Girls,

A have a issue with named ranges. I have a named range "TestRange", with
the
values "OK", "NOK".

I'm trying to test a cell against this range, so I am using something like
this:

=IF(B8=TestRange;0;1)

But checking a cell against all values within the named range doesn't seem
to work as i expected...

is there another way to implement this behaviour? Or am I doing this
completely wrong?