I have two different data sets with the following characteristics:

Data set 1: Brand names (e.g. Coca Cola) in Column A with an accompanying
number in Column B.

Data set 2: Brand names in Column C with an accompanying number in Column D.

The numbers which accompany each brand name are different. Some brands are
listed in both data sets, and some are listed in one data set or the other.

I want to create a list in which all the brands across both counts are
listed once in one column, with the accompanying number from both data sets
in the corresponding cells.

Where a Brand is counted in one data set and not the other, it will list the
number for the data set in which it was registered, and a zero for the data
set where it was not counted. Where a brand is counted in both data sets, it
will list both numbers next to the brand, cancelling out the need to list the
brand name twice.

I can do all of the above by messing around with VLOOKUP and IF functions,
but I want to try and create a template so that I can plug in two different
data sets from multiple sources. Then, the worksheet will immediately convert
the two counts into one list with the corresponding numbers from both counts
associated with each brand.

I hope this made sense! Let me know if there's anything that can be done.

Cheers,
SJay