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