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

 

[Aladin Akyurek]

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

You didn't consider the sorting issue...

 

[njimack]

How about this?
=IF(COUNTIF('P1'!K133:K135,G5),VLOOKUP(G5,'P1'!K133:L135,2),0)

 

[venraya]

oops