Having problem adding up column wondering if HLOOKUP is the cause

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 said:
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,
Click to expand...

Could you post a few examples, perhaps? i.e. what is being looked up and by
what?
 
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
 
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?
 
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)
 
It worked!!
Thank you everyone for your help, I was going crazy trying to figure it out!!!
Have a great day!
 
Back
Top