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?

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?

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?