How can I expand the IF formula to take into account additional parameters?

[simonjacobson]

I am using the formula =IF(COUNTIF($A:$A,C1),B1,"") to return the details of column B that appear when details are matched in columns A and C.

How would I expand this to also list the details in column B when contents of column C does not appear in column A?

Thank you.

[duanzhuanming]

Hi,
Try

=IF(COUNTIF($A:$A,C1)=0,B1,"")

Hope this helps!

[TMS]

If I have understood correctly, you would have:

=IF(COUNTIF($A:$A,C1),B1,B1)

But the test is then redundant so you might just as well have: =B1


If you mean, as the alternate to the version in the OP, then maybe:

=IF(COUNTIF($A:$A,C1),"",B1)

Or

=IF(COUNTIF($A:$A,C1)=0,B1,"")


Regards, TMS