I did two MATCH formulas and each column is giving back some null results,
which I expected.

I now need to find out if either of the columns has a numerical answer in it
(i.e., if there is a number in column A but a null in column B, I want a one.
If there are two nulls, I want a zero).

SUM doesnt work, IF(OR doesn't seem to work. Any ideas? Thanks in advance.