Thread
:
Vlookup to Return a Range of Data
View Single Post
#
3
Posted to microsoft.public.excel.misc
Rob
Posts: n/a
Vlookup to Return a Range of Data
The only issue is this - the "dump" of data is located on a different tab.
Example - tab #1 is the dump of data. Tab #2 is a specific store (2885), and
tab #3 is another store - and so on.
So I basically need to get all the individual store data on a specific tab
(based on the criteria).
Thanks!
Rob
"Nick Hodge" wrote:
You should look at setting up an autofilter.
DataFilterAutofilter and filter on the store#
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS
"Rob" wrote in message
...
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
Reply With Quote