MLookup not returning results

[jomili]

I've examined the code and can't discover where it differs from the code in the workbook. Can you pinpoint the difference for me?

Putting "True" at the end, using the new code, works to fill the cells with the concatenated results, which is the same thing Rick Rothsteins LOOKUPCONCAT function does. However, I'm also interested in using MLookups ability to put each result in a different cell, using the formula like so:

=MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q7))
=MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q8))

This works with the original MLookup macro on my working example, but neither option worked on the workbook I previously posted. Now with whatever change you made, the function to return concatenated results works, but returning only the 1st, 2nd, or Nth value doesn't work, instead it returns all results.

See the updated workbook attached.

[jomili]

Okay, I found the differences in the code, but can't see where the Nth Match is impacted by the changes. However, that seems to be the case. As it was originally posted, at http://www.excelfox.com/forum/f12/vl...iple-values-4/, the formula configurations were:
=MLOOKUP(T$2:T$228,A3,S$2:S$228) to return the concatenated values
=MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q7)) to return the first value matching Q7
=MLOOKUP(T$2:T$228,A7,S$2:S$228,ROWS($Q$7:Q8)) to return the second value matching Q7

Now the format is
=MLOOKUP(T$2:T$228,A3,S$2:S$228, TRUE) whcih returns the concatenated values
Anything other than TRUE returns an error.