I have a IF formula that uses the MATCH function for the SAME search column
for all areas of the IF formula - that is the LOGICAL TEST, TRUE, & FALSE
statements. Each IF sections (each formula for Logical Test, True, and False
statements) works correctly by themselves in a single cell, but when
combined in the IF statement there is a problem. The both Logical Test and
True statements MATCH lookup value is 2, and the False statement formula then
MATCH lookup value is 1. This IF formula fails to MATCH lookup the value of
1, that is when the value is 1 the IF statement should then only run the
FALSE formula because it matches 1, but for some reason in this case the
result it gives #N/A. (I'm thinking it reads the LOGICAL TEST & TRUE result
of False as #N/A, and fails to activate the FALSE formual?) How can this be
fixed? Thank you.
--
John 3:16-19