How to get rid of #n/a
 

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.

How to get rid of #n/a
 

= vlookup (a7=0,"",a7,sheet2! A4:h21,3,false )

One of these should suffice:
=IF(A7=0,"",VLOOKUP(A7,Sheet2!A4:H21,3,FALSE))
or
=IF(ISNA(VLOOKUP(A7,Sheet2!A4:H21,3,FALSE)),"",VLO OKUP(A7,Sheet2!A4:H21,3,FALSE))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Curtis" wrote:
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.