How can I lookup when match has more than one value?
Is the data sorted so that the lookup_values are grouped together or is the
data random? Is the data to be returned text or numeric?
--
Biff
Microsoft Excel MVP
"bonot1" 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, or at least a
function
that tells me there are duplicate matches?
|