Or, you could do it like this:

MOV.....John Doe.....Bill Smith
BIN.......Jane Doe
GAR.....Sam Beatty.....Jeff Jones

Biff

"andy62" wrote in message
...
There is a formula you can copy into colum B of your sheet2 that will look
up
and display all the matches you want. The challenge is that you won't
know
how many rows to leave before your next column A entry. You might be
better
off, in your Sheet2, with all the lookup items in row1, then all the
matches
below them in the same column, like this:

Row1 MOV BIN GAR
John Doe Jane Doe Sam Beatty
Bill Smith Jeff Jones


Given my expertise it would take me quite a while to customize the formula
for your example, so I'll just refer you to where I asked a similar
question
a few months ago:

http://www.microsoft.com/office/comm...b-fc5130ffd40c

Hope that helps.

"mcilwrk" wrote:

I am trying to display a list of names in one worksheet that match a
specific
"code" in another worksheet. I have tried VLOOKUP, but it stops when its
finds the first instance of the code.

Example:
Sheet 1 Sheet 2
Col A Col B Col A Col B
Code Name MOV John Doe

MOV John Doe Bill Smith
BIN Jane Doe BIN Jane Doe
GAR Sam Beatty GAR Sam Beatty
MOV Bill Smith Jeff Jones
GAR Jeff Jones

I thought about pivot tables, but I also need data from additional column
accross the page and not every row and column has data in it. (Pivit
tables
don't like blanks)

I apologoze for possibly not explaining this clearly, I would be happy to
send a sample spreadsheet to anyone who might think they can help.

Regards--
Ken McI