how to disable #N/A

[silverskye787]

I have this following codes on cell G6

=VLOOKUP(G5,'P1'!K133:L135,2)

i want it to show an empty cell instead of #N/A if it returns 0 value...

need some urgent help here.. thanks

 

[mithu81]

here you go.. this will show a 0 in the cell instead of n/a

=if(iserror(VLOOKUP(G5,'P1'!K133:L135,2),0,VLOOKUP(G5,'P1'!K133:L135,2))

 

[mithu81]

if you want to show a blank cell use this

=if(iserror(VLOOKUP(G5,'P1'!K133:L135,2),"",VLOOKUP(G5,'P1'!K133:L135,2))

 

[silverskye787]

there is still an error for this set of codes..

 

[mithu81]

=if(iserror(VLOOKUP(G5,'P1'!$K$133:$L$135,2,false),"",VLOOKUP(G5,'P1'!$K$133:$L$135,2,false)

try that

 

[mithu81]

=if(iserror(VLOOKUP(G5,'P1'!$K$133:$L$135,2,false),"",VLOOKUP(G5,'P1'!$K$133:$L$135,2,false))

try that

 

[silverskye787]

there is still an error..

it highlighted on "" this of the codes...

 

[Aladin Akyurek]

I have this following codes on cell G6

=VLOOKUP(G5,'P1'!K133:L135,2)

i want it to show an empty cell instead of #N/A if it returns 0 value...

need some urgent help here.. thanks

Assuming that K133:L135 is sorted in ascending order on K...

=IF(VLOOKUP(G5,'P1'!$K$133:K$135,1,1)=0,"",VLOOKUP(G5,'P1'!K133:L135,2,1))

 

[silverskye787]

there is still #N/A shown... i don't want anythin to be display when it return 0 value

 

[mithu81]

=if(iserror(VLOOKUP(G5,'P1'!$K$133:$L$135,2,false)),"",VLOOKUP(G5,'P1'!$K$133:$L$135,2,false))

that should work