Here's what I need to do:
I have 2 lists/tables as shown below:
I want to join the 2 tables so that if a "NAME" appear in Table X but not in Table Y, it will be listed in Table Y with a value of "0" for "SUCCESS_COUNT".
It's easy to accomplish sth like this in SQL with an outer join. Is there a way to do it in Excel(maybe with a if-then statment of some sort?) I'm not familiar with Excel programing,hope somebody could help me out.
Thanks a lot