<div>
Hi <br />
You don't need th last parameter...try<br />
=IF(COUNTIF($C30:$C7277,Sh<wbr />eet1!D2) =0,&quot;No Match &quot;, &quot;Match&quot;)
</div>


Hi
You don't need th last parameter...try
=IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", "Match")

<div>
Hi xtermie,<br />
<br />
The idea is for me to show the word 'Match' and the matching value alongside it.<br />
<br />
Thank you.
</div>


Hi xtermie,

The idea is for me to show the word 'Match' and the matching value alongside it.

Thank you.

<div>
a sorry did not understand that :)
</div>


<div>
You're welcome. Glad to help.
</div>


<div>
@xtermie<br />
It happens with all of us. sometimes we misunderstood a simple ask. :)
</div>


@xtermie
It happens with all of us. sometimes we misunderstood a simple ask. :)

<div>
<div class="content wysiwyg-content">
Heyas,<br />
<br />
I have following excel formula:<br />
<br />
=IF(COUNTIF($C30:$C7277,Sh<wbr />eet1!D2) =0,&quot;No Match &quot;, Sheet1!D2)<br />
<br />
I would like to add a string to the parameter 'value if false' eg. =IF(COUNTIF($C30:$C7277,Sh<wbr />eet1!D2) =0,&quot;No Match &quot;, &quot;Match&quot; Sheet1!D2) This gives me a formatting error. <br />
<br />
How would I go about correcting this?<br />
<br />
Thank you.
</div>
</div>


Heyas,

I have following excel formula:

=IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", Sheet1!D2)

I would like to add a string to the parameter 'value if false' eg. =IF(COUNTIF($C30:$C7277,Sheet1!D2) =0,"No Match ", "Match" Sheet1!D2) This gives me a formatting error. 

How would I go about correcting this?

Thank you.

Excel CountIf Formatting Query Adding String to 'Value if False' Parameter

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.