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.
|