Hi All
Could anyone please provide me with some help regarding a UDF which returns all partial matching entries? I am hoping that it will work much like an index(match) (or vlookup) function but returns all values that contain the base string, e.g.
Reference value: aaa
Reference array: baaab, caaab, abaaab, bbba, ccaab etc.
The function will return: "baaab, caaab, abaaab"
The solution would ideally be a modification of a solution found in an older thread:
http://www.excelforum.com/excel-new-...90#post3157990
Any help is greatly appreciated.
Bookmarks