Remove #N/A result from Index/Match/Count Formula

[Valthanos]

I have the below formula, which runs fine but shows #N/A in all cells after the series has ran. How do I remove the #N/A output? I have tried If/Than, If Error, Etc. but I get too many arguments error.

=(INDEX(glass2,MATCH(0,COUNTIF($D$6:D10,glass2&""),0)))

[TABLE="width: 495"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]Glass Type[/TD]
[TD][/TD]
[TD]Total Sq/Ft[/TD]
[TD]Total Budget[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]3/4" clear tempered[/TD]
[TD] [/TD]
[TD]474.50[/TD]
[TD]$15,865.76[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]3/4 clear tempered - etched[/TD]
[TD] [/TD]
[TD]599.33[/TD]
[TD]$23,619.04[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]1/2" clear tempered[/TD]
[TD] [/TD]
[TD]392.00[/TD]
[TD]$7,297.90[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD="align: center"]#N/A[/TD]
[TD] [/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD="align: center"]#N/A[/TD]
[TD] [/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD="align: center"]#N/A[/TD]
[TD] [/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: center"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

=IFERROR((INDEX(glass2,MATCH(0,COUNTIF($D$6:D10,glass2&""),0))),"")

basically

=IFERROR(<formula>,"")

 

[JoeMo]

Try:

=IFERROR(INDEX(glass2,MATCH(0,COUNTIF($D$6:D10,glass2&""),0)),"")

 

[Valthanos]

That returns with "too many arguments."

 

[Special-K99]

Then your formula has "too many arguments"

 

[Valthanos]

Then your formula has "too many arguments"

Whats the point of posting a comment if you are not providing any help? Clearly I am aware there are too many arguments, and I do not know how to achieve what I am trying to achieve.