Home |
Search |
Today's Posts |
#1
|
|||
|
|||
#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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
ERROR | Excel Discussion (Misc queries) | |||
Error when entering and exiting excel | Excel Discussion (Misc queries) |