=vlookup() returns the information from the first match it finds. It doesn't
bring back multiple values.

Maybe you can change the layout of that table.
Put the mailcode in column A and then the first description in column B, the
second in column C, the third in column D, ...

And use a few =vlookup()'s to bring back each of those descriptions.

wrote:

Hello—I am trying to write a simple vlookup. My formula is working as
designed but is only offering me a partial solution. What I would
like to do is to have the formula look a one list of mail codes, then
look at the other list of mail codes that correspond, and if there is
a description for that mail code, pull that description over. The
issue, however, is that more than one description can be tied to a
mail code. The way that I currently have my formula written, it will
only pull in the first description associated to that mail code, but
lops off all of the others, thus only returning partial results. Here
is my current formula:

=VLOOKUP(F:F, [Book1]Sheet1!$A:$B, 2, FALSE)

Where “A” = mailcode and B=description.

Is there any way around this?

--

Dave Peterson