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.