Having problem adding up column wondering if HLOOKUP is the cause
 

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

Having problem adding up column wondering if HLOOKUP is the cause
 

"H" wrote:

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

Could you post a few examples, perhaps? i.e. what is being looked up and by
what?

Having problem adding up column wondering if HLOOKUP is the cause
 

Hi H

You will probably find that in column E one or more of the hlookup's results
in #N/A and this is causing the same result in column F. Sort out the error
in E and you will be able to sum column F.

Chris

"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

Having problem adding up column wondering if HLOOKUP is the ca
 

Bigwheel,
Thanks for your response.
Column D is a price
Column E is a % that is being looked up on another sheet by HLOOKUP
Column F is D*F giving another price
Does this help?

--
-H


"bigwheel" wrote:

"H" wrote:

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

Could you post a few examples, perhaps? i.e. what is being looked up and by
what?

Having problem adding up column wondering if HLOOKUP is the cause
 

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

Having problem adding up column wondering if HLOOKUP is the ca
 

It worked!!
Thank you everyone for your help, I was going crazy trying to figure it out!!!
Have a great day!
--
-H


"Tom Ogilvy" wrote:

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