how to remove #N/A?

[gigiyi]

---

A B C D E G H I J K
[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[TD]
[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]3[/TD]
[TD]#N/A[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]0[/TD]
[TD]1[/TD]
[TD]0[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]#N/A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]4[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]0[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]#N/A[/TD]
[TD]#N/A[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]



TOTAL: 3 0 3 3 2

G2: =(INDEX($A2:$E2,MATCH(G$1,$A2:$E2,0)))
H2 :=(INDEX($A2:$E2,MATCH(H$1,$A2:$E2,0)))


may I ask how to remove #N/A, instead just leave it blank?

thanks for help

gigi

 

[Jonmo1]

Depends on which version of Excel you're using. This assumes XL2007+

=IFERROR(INDEX($A2:$E2,MATCH(G$1,$A2:$E2,0)),"")

 

[gigiyi]

THANK YOU Jonmo1

 

[Jonmo1]

You're welcome