Actually, you're returning the values from the same row (single unique key to
match). That UDF returns values from different rows when the key is duplicated
in the table.

TommySzalapski wrote:

If that confuses you, you could just concatenate multiple vlookups
Concatenate(vlookup(A1, B1:D7, 2, false), vlookup(A1, B1:D7, 3, false))
and so on, but Dave's solution is cleaner. It's just pretty complex if
you've never used UDFs.

Szalapski

--
TommySzalapski
------------------------------------------------------------------------
TommySzalapski's Profile: http://www.excelforum.com/member.php...o&userid=25561
View this thread: http://www.excelforum.com/showthread...hreadid=395310

--

Dave Peterson