I don't know what article you are talking about? I have an example that can
be downloaded
from here


http://www.nwexcelsolutions.com/advanced_function_page.htm#6._You_can_use_a_combin ation_of_functions_to_return_more_than_one_value,_ with_the_lookup_value_in_A1_and_the_lookup_table__ in_First!$A$1:$B$20_where_we_want_to_return_the_va lues_in_B1:B20


here's the direct link below




http://nwexcelsolutions.com/Download...20lookup .xls

--


Regards,


Peo Sjoblom

"MRLYONS68" wrote in message
...
I have also tried to use this article, but I am getting "#NUM" error values
using the "SMALL" mixed with the "ROW" functions. I am following the
example
verbatim, and I do not think this should be that difficult. This article
attempts to do EXACTLY what I am looking for.

Does anyone know of where the actual example can be downloaded as some of
the formulas are truncated?

Regards,

Mike

"Niek Otten" wrote:

Look he

http://office.microsoft.com/en-us/ex...260381033.aspx

Unfortunately, the formulas are truncated. But the text explains very
well what to do, so hopefully you can manage.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"farhad" wrote in message
...
|I am using LOOKUP functions to retrieve info from a list. Some of the
lookup
| values have more than one match in the list. Is there a function that
allows
| me to retrieve multiple elements for one lookup value? Offcourse the
data is
| in random order, and the data to be returned is text. I need to have
all the
| records that lookup retrieve it on the same rows.
|