copy paste value
 

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

copy paste value
 

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