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 |
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) |