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 :/