Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Defined Names
I am try to create a formula where it will look up a range of defined names
and then look for a value on that range found. how would i do that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Defined Names
What does ... look for a value on that range ... mean?
-- HTH Bob "Lelethu" wrote in message ... I am try to create a formula where it will look up a range of defined names and then look for a value on that range found. how would i do that? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing Defined Names
The below formula will check whether the name specified in E7 exists in the
list of names in G1:G10 and if found search the search string specified in cell E8 in that named range and returns the status...Try and feedback E7 = name E8 = search string =IF(ISNA(MATCH(E7,G1:G10,0)),"Name not found", IF(ISNA(MATCH(E8,INDIRECT(E7),0)),"Entry not found","Found")) -- Jacob "Lelethu" wrote: I am try to create a formula where it will look up a range of defined names and then look for a value on that range found. how would i do that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why use defined names? | Excel Discussion (Misc queries) | |||
defined names | Excel Worksheet Functions | |||
Defined names | Excel Worksheet Functions | |||
NAMES DEFINED | Excel Discussion (Misc queries) | |||
Changing Multiple Defined Names At Once? | Excel Discussion (Misc queries) |