Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vlookup
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup a Vlookup | Excel Worksheet Functions | |||
VLOOKUP Problem | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions | |||
Have Vlookup return a Value of 0 instead of #N/A | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions |