Have data spread sheet using vlookup, when I leave A7 cell blank this roll
has #n/a the column A1 to A50 are my lookup, if I use any lookup it works but
if left any cell blank I have tons of #n/a how do you get rid of them or fix
it where it doesnt show when not used. I have try this data = vlookup (
a7=0,"",a7,sheet2! A4:h21,3,false )
this does not help.