Hello,
Can you please help me how to write a macro for searching multiple named ranges?
I have following dynamic named ranges
List1
List2
List3
List4
List5
List6
List7
List8
I would like to search them all (even for similar results, so that the person does not need to type exact match) and return the name of the named range in which the data was found.
But I do not want to return names List1, List2, etc. but names that I have in a separate lookup table on Sheet2 for these lists,
list1 colors list2 animals list3 clothes
etc.
So that If I type into a dialog box : "eleph" it would lookup elephant and would return name "animals" that was looked up in the table on sheet2 for list2.
Thank you very much
Bookmarks