Changing Defined Names

  • Thread starter Thread starter Lelethu
  • Start date Start date
L

Lelethu

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?
 
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"))
 
Back
Top