MLookup not returning results

[Admin]

Hi

The Nth match is the 4th parameter. So your formula would be

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

or Nth match by omitting the Number as text

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

[jomili]

Thanks Admin, that did the trick! Just a suggestion, but this is my second question on MLookup (I posted earlier about how to use it). Do you think both the direction on how to use, and the updated version you just provided, should be placed with the Original Posting (http://www.excelfox.com/forum/f12/vl...iple-values-4/)?