Column F will show #N/A if column E shows #N/A. to avoid it, in F2 for
example, use:

=if(iserror(E2),"",D2*E2)

--
Regards,
Tom Ogilvy


"H" wrote in message
...
Column D is a number entered manually
Column E has an HLOOKUP formula in it
Column F is D*E
I can add column D no problem
When I try to add column F I get an error- #N/A
Does anyone know how I can copy this column?
Thank you,
--
-H