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