vlookup gives me a #N/A
=if(isna(vlookup(...)),"",vlookup(...))
Alamo wrote:
Excel automatically corrects this formula with 3 ))) at the end of the formula.
In my case it is:
=IF(ISNA(VLOOKUP(B44,itemlist!$A16:$B126,2)),0,(VL OOKUP(B44,itemlist!$A16:$B126,2)))
I do not want the 0 to show up on the form - how can it be blank?
Mike Boehmer
San Antonio, TX
Home of the NBA Champs - The SPURS-
"Richard Buttrey" wrote:
On Thu, 13 Oct 2005 07:26:01 -0700, "dave"
wrote:
When I try to look with vlookup for a value that is not in the table
indicated, I get the message #N/A which indicates that the value cannot be
found (this is normal).
I would like to change this message #N/A into a value 0 or a blanc ""
because you cannot calculate with this value.
Is this possible??
Just wrap your vlookup in an If statement. i.e.
If(isna(vlookup(blah_blah)),0,vlookup(blah_blah))
Rgds
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
--
Dave Peterson
|