Thread: Checking a cell against a named range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Memento Memento is offline
external usenet poster
  
Posts: 26
Default Checking a cell against a named range
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?
Reply With QuoteReply With Quote