Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello,
Heres my issue - I have a single piece of criteria (ie - Store #), and given this, I need to look at a large dump of data, and return all the values for this particular store number. Example : Here is the data dump : A B C D Store # Account # Date Amount 1 2885 120000 05/17/06 100.00 2 2950 130405 06/17/06 50.00 3 2885 130402 04/20/04 200.00 4 2950 126210 08/17/05 50.00 Now, If I am running a report on Store #2885 - what I need the formula to do is give me all pieces of information that relate to that store. Here is what the end result of the formula should be : Store # Account # Date Amount 2885 120000 05/17/06 100.00 2885 130402 04/20/04 200.00 Can anybody help me ? Thanks! Rob |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Look up Data from Worksheet within same Workbook | Excel Discussion (Misc queries) | |||
Look up Data from Worksheet within same Workbook | New Users to Excel | |||
VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
Lookup & Return Range of Data | Excel Discussion (Misc queries) | |||
Vlookup for data contained in a cell | Excel Worksheet Functions |