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