| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| get data from a cell in each named range | Excel Worksheet Functions | |||
| I want to use a cell Value as a named Range in a Formula | Excel Worksheet Functions | |||
| inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
| named cell range | Excel Worksheet Functions | |||
| Getting a named range from a cell value | Excel Worksheet Functions | |||
Threaded Mode
