How to dedouble transactions

Occasional Visitor


I have a list from Google Analytics with transaction ID's and a list from our affiliate partner with their transaction ID's for which we are charged commission.

I wish to dedouble the transaction ID's from the affiliate partner with our Analytics data transactions. Why: because some transactions from the affiliate partner are not registered in the Analytics data and therefore can not be attributed.

How can I do this using Excel? I know the vlookup function might do it but I don't know how to properly do it :/

Thanks in advance for any kind of help or advice! 


1 Reply
Can you perhaps post an anonymised example of the data?
Related Conversations
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies