ok here is the situation on one sheet i have a list of credit accounts
(always changes - not sure which card numbers or how many times different
ones will be entered), and with these card numbers, customer enters what they
plan to purchase and the amount..sort of looks like this:

CARD NUMBER PURCHASE PRICE
12345 CAR 26,000
55599 BOAT 30,000
999122 TV 3,000
55599 CLOTHES 1,200
55599 STEREO 600
999122 DINNER 50

OK, now on the next sheet is a listing of the Card Numbers and I want it to
grab all the expected purchases for each card number listed on first sheet,
can you use a VLOOKUP to return multiple lines of data...so if my second
sheet looks like this:

CARD NUMBER PURCHASE
12345 VLOOKUP HERE
55599 VLOOKUP HERE
999122 VLOOKUP HERE

as they enter more purchases on different lines on sheet one, how can i make
these items appear on sheet two? I need it to go on seperate lines so that i
end up with this on sheet 2:

CARD NUMBER PURCHASE
12345 CAR
55599 BOAT
CLOTHES
STEREO
999122 TV
DINNER

IS THIS POSSIBLE? How can i get it to automatically put in additional lines
as sheet one changes?

I hope this makes sence.

and thank you so much for any help

Hi, the best way to solve it and meets your needs is PIVOT TABLE.

take a look here
http://www.contextures.com/tiptech.html

if you need some help with PT.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"chris" escreveu:

ok here is the situation on one sheet i have a list of credit accounts
(always changes - not sure which card numbers or how many times different
ones will be entered), and with these card numbers, customer enters what they
plan to purchase and the amount..sort of looks like this:

CARD NUMBER PURCHASE PRICE
12345 CAR 26,000
55599 BOAT 30,000
999122 TV 3,000
55599 CLOTHES 1,200
55599 STEREO 600
999122 DINNER 50

OK, now on the next sheet is a listing of the Card Numbers and I want it to
grab all the expected purchases for each card number listed on first sheet,
can you use a VLOOKUP to return multiple lines of data...so if my second
sheet looks like this:

CARD NUMBER PURCHASE
12345 VLOOKUP HERE
55599 VLOOKUP HERE
999122 VLOOKUP HERE

as they enter more purchases on different lines on sheet one, how can i make
these items appear on sheet two? I need it to go on seperate lines so that i
end up with this on sheet 2:

CARD NUMBER PURCHASE
12345 CAR
55599 BOAT
CLOTHES
STEREO
999122 TV
DINNER

IS THIS POSSIBLE? How can i get it to automatically put in additional lines
as sheet one changes?

I hope this makes sence.

and thank you so much for any help

Perhaps you could just sort the list and copy....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"chris" wrote in message
...
ok here is the situation on one sheet i have a list of credit accounts
(always changes - not sure which card numbers or how many times different
ones will be entered), and with these card numbers, customer enters what
they
plan to purchase and the amount..sort of looks like this:

CARD NUMBER PURCHASE PRICE
12345 CAR 26,000
55599 BOAT 30,000
999122 TV 3,000
55599 CLOTHES 1,200
55599 STEREO 600
999122 DINNER 50

OK, now on the next sheet is a listing of the Card Numbers and I want it
to
grab all the expected purchases for each card number listed on first
sheet,
can you use a VLOOKUP to return multiple lines of data...so if my second
sheet looks like this:

CARD NUMBER PURCHASE
12345 VLOOKUP HERE
55599 VLOOKUP HERE
999122 VLOOKUP HERE

as they enter more purchases on different lines on sheet one, how can i
make
these items appear on sheet two? I need it to go on seperate lines so
that i
end up with this on sheet 2:

CARD NUMBER PURCHASE
12345 CAR
55599 BOAT
CLOTHES
STEREO
999122 TV
DINNER

IS THIS POSSIBLE? How can i get it to automatically put in additional
lines
as sheet one changes?

I hope this makes sence.

and thank you so much for any help