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?

You have a response at your other post.

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