| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with HLookup. Not sure if it is a bug or not | Excel Worksheet Functions | |||
| Problem in adding the Column | Excel Discussion (Misc queries) | |||
| hlookup problem | Excel Discussion (Misc queries) | |||
| hlookup problem | Excel Discussion (Misc queries) | |||
| Problem adding column of figures | New Users to Excel | |||
Linear Mode
