Thread
:
Displaying multiple matches
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Displaying multiple matches
try datafilterautofilter
--
Don Guillett
SalesAid Software
"mcilwrk" wrote in message
...
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett