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.




Reply With Quote
Bookmarks