V LOOKUP problem

  • Thread starter Thread starter cakonopka
  • Start date Start date
C

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
 
cakonopka said:
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
Click to expand...

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