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