Prev: Columns labeled with numbers not letters
Next: Centreing Text In Excel Cells
From: Tomwireless on 22 Apr 2010 10:30
I have a colum of vlookup numeric data and want to add it up, but each cell
may not return a value depending on how many items are needed. I belive I
will need to add a colum in and grab the numeric data that is returned and
then use a formula to do a copy paste value and if no value equal zero. I am
not sure how to do this thoe. here is the vlookup formula i am using.
Can you please help

=IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
Items'!$C$1,FALSE)))

Thank you
From: Duke Carey on 22 Apr 2010 10:58
Tom - at a guess, what you are trying to do is use a formula along the lines of

=A2+A3+A4+A5

and that generates an error when one of those cells has a formula where the
value is "" from =IF(ISNA(...),"",...)

The way around that is to use the SUM() function on your column. It will
not throw an error if one or more values is ""


"Tomwireless" wrote:

> I have a colum of vlookup numeric data and want to add it up, but each cell
> may not return a value depending on how many items are needed. I belive I
> will need to add a colum in and grab the numeric data that is returned and
> then use a formula to do a copy paste value and if no value equal zero. I am
> not sure how to do this thoe. here is the vlookup formula i am using.
> Can you please help
>
> =IF(ISNA(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
> Items'!$C$1,FALSE)),"",(VLOOKUP(A3,'Inventory Items'!$A$3:$C$888,'Inventory
> Items'!$C$1,FALSE)))
>
> Thank you
 | 
Pages: 1
Prev: Columns labeled with numbers not letters
Next: Centreing Text In Excel Cells