vlookup for mult. occ

[charlie]

I have a pivot table which sums and counts invoices. Some
invoices have more than one charge. I want to put a
vlookup formula out to the side to find each individual
amount on those invoices. (there are plenty of empty
columns to the right).

invoice amount
1000 200.00
1001 50.00
1001 100.00

Thanks for your help.