Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|