Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a Single cell in a name range
Is anyone there who can help me out?
What is the formula needed to refer a single cell in a named range of cells. I mean, I want to compare a cells value with any of the cell values in the named range. let the named range be "holidays" |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refer to a Single cell in a name range
To identify a specific cell in a range, say the 5th cell in there you
use INDEX: =INDEX(holidays, 5) To see if a cell's value appears in holidays you use MATCH: =MATCH(A2, holidays, 0) This returns the position of A2 value in holidays. If the value of A2 is not found in holidays this returns the #N/A error. If you want to test if the value appears in holidays you check if MATCH returns a number: =IF(ISNUMBER(MATCH(A2, holidays, 0))," In set", "Not in set") HTH Kostis Vezerides Jitendra Kumar wrote: Is anyone there who can help me out? What is the formula needed to refer a single cell in a named range of cells. I mean, I want to compare a cells value with any of the cell values in the named range. let the named range be "holidays" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Named Range reference via single Cell | Excel Discussion (Misc queries) | |||
named Range Referenced vai single cell | Excel Discussion (Misc queries) | |||
Can't highlight a single cell. Creates a range when I move curso | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) |