=IF($I$2="Active",VLOOKUP($E6,Data!$G$4:$AT$1587,2 8,0),"0")

I have this formula above in a cell. I want to add that if the vlookup
doesn't find anything and returns a #N/A than give me ZERO.

I'm doing this so I don't get #n/a in the column and my totals will add up
without giving me #n/a.

Any help? B.