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