Thank you for the 0 vs the "". It did the trick. And thanks to the other
responders for their advice. It is very appreciated.
--
inthestands


"inthestands" wrote:

I have a vlookup formula where I am looking at three different warehouses to
locate the amount of material that I have on order. 1 or 2 of the
spreadsheets will sometimes not have the same sku in the warehouse. I assume
this is why I am getting the #VAULE! Response. I have copied the formula
that I am using. How can I correct it so that I can get the quantities when
there are some, but not have the #VALUE response show at all. I would prefer
that a blank shows instead.

=IF(ISNA(VLOOKUP(B2,'data sac'!$A$2:$M$5903,13,0)),"",VLOOKUP(B2,'data
sac'!$A$2:$M$5803,13,0))+IF(ISNA(VLOOKUP(B2,'data
sj'!$A$2:$M$5903,13,0)),"",VLOOKUP(B2,'data
sj'!$A$2:$M$5803,13,0))+IF(ISNA(VLOOKUP(B2,'data
mod'!$A$2:$M$5903,13,0)),"",VLOOKUP(B2,'data mod'!$A$2:$M$5803,13,0))

Thanks in advance
--
inthestands