Excel help?
I think you can do this, but I am not sure how!
I have two lists
One of transactions, one of cards and card owners. In list 1 there are sometimes many transactions on one card. In List 2 there is 1 line for each card and card owner
I want to basically add the Account number to the transaction file.
I used vlookup so that in List 2 I only have cards that appear in list 1, but because there are sometimes more than one transaction on a card I cant figure out how to add the account number.
(I dont have any tools other than Excel to do it)
I cant do it just by sorting as there are 11,000 transactions and 5,000 diff cards and it would take hours.
LIST 1_____LIST 2
Card 1 £100 Card 1 Acc1919
Card 1 £150 Card 2 Acc 9191
Card 2 £100 Card 3 Acc 8000
Card 3 £100 Card 4 Acc 8000
Card 4 £1
Card 4 £15
etc
I want it to say
Card 1 £100 Acc 1919
Card 1 £150 Acc 1919
Card 2 £100 Acc 9191
etc
__________________
"Do not tell lies, and do not do what you hate,
for all things are plain in the sight of Heaven. For nothing
hidden will not become manifest, and nothing covered will remain
without being uncovered."
The Gospel of Thomas
|