#N/A error
 

this is the formula I am using to make up an order form
=VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A3
A3 being quanity, how can I get rid of the error message. I have tried
wrapping it in IF (ISNA but it only works if I leave off the *A3

Hi Sharon

try

=IF(ISNA(VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE) ),"",VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A 3
)

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"sharon" wrote in message
...
this is the formula I am using to make up an order form
=VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A3
A3 being quanity, how can I get rid of the error message. I have tried
wrapping it in IF (ISNA but it only works if I leave off the *A3

Hi

IF(ISNA(VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE), "",VLOOKUP(C3,PRODUCTS!$A$
2:$U$6000,6,FALSE)*A3 )

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"sharon" wrote in message
...
this is the formula I am using to make up an order form
=VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A3
A3 being quanity, how can I get rid of the error message. I have tried
wrapping it in IF (ISNA but it only works if I leave off the *A3

Hi!

What value do you want to return if ISNA is true? If you use 0 the formula
should just return 0 as 0*A3 will equal 0. If you want blank, "", then put
the Value_If_False argument inside ( ):

For 0:

=IF(ISNA(VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE) ),0,VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE
))*A3

For blank, "":

=IF(ISNA(VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE) ),"",(VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE
)*A3))

Biff

"sharon" wrote in message
...
this is the formula I am using to make up an order form
=VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A3
A3 being quanity, how can I get rid of the error message. I have tried
wrapping it in IF (ISNA but it only works if I leave off the *A3

Since your datalist is 6,000 rows and over 20 columns, you may want to try
using this type of formula in order to perhaps speed up the calc time on
your WB.

This combination of functions should run more efficiently then a double
Vlookup:

=IF(ISNA(MATCH(C3,Products!$A$2:$A$6000,0)),"",IND EX(Products!$A$2:$U$6000,M
ATCH(C3,Products!$A$2:$A$6000,0),6)*$A$3)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"sharon" wrote in message
...
this is the formula I am using to make up an order form
=VLOOKUP(C3,PRODUCTS!$A$2:$U$6000,6,FALSE)*A3
A3 being quanity, how can I get rid of the error message. I have tried
wrapping it in IF (ISNA but it only works if I leave off the *A3