Eliminate the #VALUE! response.
Good Point T Valko.
"T. Valko" wrote:
The problem is that you're adding the results of all the lookups together.
If any return "" that causes the #VALUE! error. You could return 0 instead
of "" and that'll correct the #VALUE! error. Then, if you don't want to see
the result as 0 you could use conditional formatting to hide the 0.
--
Biff
Microsoft Excel MVP
"inthestands" wrote in message
...
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
|