#N/A error

[Guest]

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

 

[JulieD]

Hi Sharon

try

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

 

[Arvi Laanemets]

Hi

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

 

[Biff]

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

 

[RagDyeR]

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)),"",INDEX(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!
==============================================


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