V LOOKUP problem

[cakonopka]

Hi All

Im new here and need a little help with my V-Lookup formula.

I am making an invoicing system and use a vlookup formula to bring th
product name, description and unit cost. The only problem is i have t
copy the formula to an average of 20 boxes in a list. Sometimes in th
invoice people dont order 20 items but when there is a free line, al
that i see is N/A. How can i change the formula to show that if ther
is no product number entered.

if any help could be given or if you need a copy of the system to wor
it out please e-mail me

cheers

from C

 

[Paul]

Hi All

Im new here and need a little help with my V-Lookup formula.

I am making an invoicing system and use a vlookup formula to bring the
product name, description and unit cost. The only problem is i have to
copy the formula to an average of 20 boxes in a list. Sometimes in the
invoice people dont order 20 items but when there is a free line, all
that i see is N/A. How can i change the formula to show that if there
is no product number entered.

if any help could be given or if you need a copy of the system to work
it out please e-mail me

cheers

from CK

Wrap your formula in an IF statement. So, if your product number is in A1,
use
=IF(A1="","",YourFormula)

 

[Peo Sjoblom]

Maybe

=IF(A2="","",VLOOKUP(A2,B2:C20,2,0))