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