Changing Defined Names

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?
 
J

Jacob Skaria

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"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
How do I have a cell value define a dynamic named range? 15
Newbie Help - IF Yes No Function 0
Define minimum function 0
Crating User Form to Add Names 1
Create Range by joining multiple Ranges - passing multiple holidayranges to Workday function 6
Conditional formatting 2
Getting sum of values in another sheet while using condition 5

Top