If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|