Vlookup to Return a Range of Data

Giganews Newsgroups
Subject: Vlookup to Return a Range of Data
Posted by:  Rob
Date: Mon, 29 May 2006

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

Replies