Hi,
Brian Barker schrieb:
At 21:28 18/09/2013 +0100, Mark Bourne wrote:
Carl Paulsen wrote:
I'm trying to build an IF statement that tests if a condition exists
in two columns, and assigns the number 1 if it does, and 0 if not.
The columns being checked are vLookups which return #N/A if an ID
At 17:40 19/09/2013 +0200, Regina Henschel wrote:
Brian Barker schrieb:
At 21:28 18/09/2013 +0100, Mark Bourne wrote:
Carl Paulsen wrote:
I'm trying to build an IF statement that tests if a condition
exists in two columns, and assigns the number 1 if it does, and 0
if not. The columns being
I'm trying to build an IF statement that tests if a condition exists in
two columns, and assigns the number 1 if it does, and 0 if not. The
columns being checked are vLookups which return #NA if an ID is not
found in another table. I'm trying to search for cases where an ID# IS
returned in
Carl Paulsen wrote:
I'm trying to build an IF statement that tests if a condition exists in
two columns, and assigns the number 1 if it does, and 0 if not. The
columns being checked are vLookups which return #NA if an ID is not
found in another table. I'm trying to search for cases where an ID#
At 21:28 18/09/2013 +0100, Mark Bourne wrote:
Carl Paulsen wrote:
I'm trying to build an IF statement that tests if a condition
exists in two columns, and assigns the number 1 if it does, and 0
if not. The columns being checked are vLookups which return #N/A if
an ID is not found in another