Help Editing UDF

[Impartial Derivative]

I currently have a UDF that conducts a vlookup search and returns all values that meet the search criteria. The vlookup portion of the code works very effectively however the results are displayed in a concatenated fashion in one single cell. I would like to be able to change the UDF to display each returned value in its own cell. I know what portion of the code is creating the concatenation in the returned data string but I'm not sure how to change this to report in different cells. The UDF is displayed below:

Please Login or Register  to view this content.

[MrShorty]

when I've had to do this, I've set it up to return an array. This means the UDF has to be entered as an array function over the range where you want the results, but it generally works pretty well. Adapted code:

Please Login or Register  to view this content.