Match values and insert rows for non-matching values

[Portmanteau]

Hi there,
I really need some help with something I suspect is pretty basic:
I have website names in column A with their associated revenue in column B. In column C are website names from another month, with their associated revenues in column D.
A B C D
bob.com 0.5 tim.com 0.4
tim.com 0.2 bob.com 0.3
joe.com 0.3 zack.com 0.2

I need a way to alter the two lists so that they display the same list of domain names, but where a name that appears in A but not in B is filled-in as a 0 in column B, and vice versa. For instance:
A B C D
bob.com 0.5 bob.com 0.3
tim.com 0.2 tim.com 0.4
joe.com 0.3 0 0
0 0 zack.com 0.2
I tried using the formula =IF(ISNUMBER(MATCH(A2,B:B,0)),A2,""), but that only gives me part of what I'm looking for.
Many advance thanks for your help!

[MickG]

Hi, Try this. The Results are in column "H" , But you can alter the Range at the Bottom of the code.
I Assumed your Data is in columns "A to D" row (1) on.

Please Login or Register  to view this content.

Regards Mick