I think you'll find that vlookup, hlookup and match work by finding the first
matching value then returning values in adjacent columns or rows. You would
get better results by filtering the data then copying and pasting into your
second sheet.

"Nate" wrote:

Date SHTO City Tank Prod. #
6/1/2006 8 Amery 1 160KK
6/1/2006 2 Cannon 1 160KP
6/1/2006 21 Northfield 1 160KK
6/1/2006 14 Baldwin 1 160KP
6/5/2006 40 Burnsville 1 160AA
6/5/2006 8 Amery 1 160KK
6/5/2006 2 Cannon 1 160KP
6/5/2006 21 Northfield 1 160KK
6/10/2006 40 Burnsville 1 160AA

I'm trying to do a vlookup formula in a seperate spreadsheet that uses
column B as the key - and then spits out the entire row's content into that
spreadsheet (i.e. column a, b, c, d, and e). So for SHTO 8 - I would only
want the two entries on 6/1 and 6/5 to be on that seperate spreadsheet - and
have the formula ignore all other SHTO's in the set of data. I'm not sure if
vlookup, hlookup, or match would be the best solution for this problem? Let
me know if you have any ideas?

Thanks ahead of time,
Nate