Thread
:
#N/A error
View Single Post
#
1
sharon
Posts: n/a
#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
Reply With Quote