#value error

B

BSantos

Hi,

I am using the
=if(ISNA(VLOOKUP(A8,Productlist,2,FALESE)),"",VLOOKUP(a8,Productlist,2,false))
in one cell and again on the next cell to the right of it. I have the next
same subtracting from the first cell example =(g8-h8)and it comes back with a
value.... can anyone tell me the remedy to fix this problem?

thanks B.
 
A

Aladin Akyurek

Either let the lookup formulas return 0 instead of "" or apply:

=N(G8)-N(H8)

instead of

=G8-H8
 
Top