Pasting and Referencing

[Johnny4strings]

Hello,
I am working with a multi column list of data that am pasting into one tab. This tab is going to be sorted into other tabs by referencing one cell e.g. a zip code.
I have made a vlookup, referencing the one cell containing the zip code, however for my results, I get only the first record in the list. Is there a way to modify my vlookup formula so that it continues down the list and give me the next record instead of a duplicate?
The vlookup formula is:
=VLOOKUP(REFERENCE CELL, ARRAY FROM IMPORTED LIST, 1,1)
Thanks!
John

 

[pbornemeier]

VLOOKUP only returns a single result. After a match you could reduce the size of the input array to all rows after the match and execute it again to see the next match in the remaining data.
You may want to consider using the Autofilter to show only rows that have a matching zip then copy visible rows to the appropriate tab.