<div>
Wrap up your original in an IFERROR(value, value_if_error) function as in below... 
 
=IFERROR(IF(COUNTIF(Sheet2!$A:$A,$J4),VLOOKUP($J4,Sheet3!$A:B,2,FALSE),&quot; &quot;),&quot; &quot;)
</div>

<div>
The problem is in the IF statement. 
Correct use would be 
<pre><code class="code-1 nolinks" id="code-20-38175453-1">=IF(condition, value if true, value if false)
</code></pre>
 
you are using 
<pre><code class="code-1 nolinks" id="code-20-38175453-2">=IF(condition1, value if 1 true, value if 1 false, condition2, value if 2 true, value if 2 false)
</code></pre>
 
instead you should use 
 

<pre><code class="code-1 nolinks" id="code-20-38175453-3">=IF(condition 1, value if 1 true, IF(condition 2, value if 2 true, value if 2 false))
</code></pre>
 
thus 
 

<pre><code class="code-1 nolinks" id="code-20-38175453-4">=IF(
	COUNTIF(Sheet2!$A:$A,$J1),
	VLOOKUP($J1,Sheet3!$A:B,2,FALSE),
	IF(
		ISNA(VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),
		&quot;&quot;,
		VLOOKUP($J1,Sheet3!$A:B,2,FALSE)
 )
 )
</code></pre>
</div>

<div>
=IF(COUNTIF(Sheet2!$A:$A,$J1),VLOOKUP($J1,Sheet3!$A:B,2,FALSE),IF(ISNA(VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),&quot;&quot;,VLOOKUP($J1,Sheet3!$A:B,2,FALSE)))
</div>

<div>
It is the value_if_true that needs to be wrapped, as an alternative to my catch all solution above: 
 

<pre><code class="code-1 nolinks" id="code-20-38175492-1">=IF(COUNTIF(Sheet2!$A:$A,$J1),IF(ISNA(VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),&quot;&quot;,VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),&quot;&quot;)
</code></pre>
</div>

<div>
I found this out when I tried the corrected formula and it still returned the NA values. &nbsp;SO I took away the countif then and its perfect.
</div>

<div>
<div class="content wysiwyg-content">
I have a nested if 
 
=IF(COUNTIF(Sheet2!$A:$A,$J1),VLOOKUP($J1,Sheet3!$A:B,2,FALSE),&quot; &quot;,IF(ISNA(VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),&quot;&quot;,VLOOKUP($J1,Sheet3!$A:B,2,FALSE))) 
 
and I am getting the error that I have entered too many arguments for this function. 
 
Any help? 
 
Too give a little backgroumd on this formula.... 
Basically before I had 
 
=IF(COUNTIF(Sheet2!$A:$A,$J4),VLOOKUP($J4,Sheet3!$A:B,2,FALSE),&quot; &quot;) 
 
But it was pulling in a lot of NA's, even after my first filter for getting less NA's (the count if). &nbsp;So I am just trying to say ok so even after the count if, if the result is still NA then show a blank. 
 
Thanks in Advance!
</div>
</div>

I have a nested if 

=IF(COUNTIF(Sheet2!$A:$A,$J1),VLOOKUP($J1,Sheet3!$A:B,2,FALSE)," ",IF(ISNA(VLOOKUP($J1,Sheet3!$A:B,2,FALSE)),"",VLOOKUP($J1,Sheet3!$A:B,2,FALSE)))

and I am getting the error that I have entered too many arguments for this function.

Any help?

Too give a little backgroumd on this formula....
Basically before I had

=IF(COUNTIF(Sheet2!$A:$A,$J4),VLOOKUP($J4,Sheet3!$A:B,2,FALSE)," ")

But it was pulling in a lot of NA's, even after my first filter for getting less NA's (the count if).  So I am just trying to say ok so even after the count if, if the result is still NA then show a blank.

Thanks in Advance!

You've entered too many arguments for this function excel 2010

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.