Prev: Linking data from one worksheet to another...
Next: Convert text entered as minutes/seconds to minutes
From: Lisa Kansas City on 5 May 2010 14:48
Thank you- this was great!!

"T. Valko" wrote:

> Try one of these:
>
> Returns a blank:
>
> =IF(ISNA(VLOOKUP(.....)),"",VLOOKUP(.....))
>
> Returns a 0:
>
> =IF(ISNA(VLOOKUP(.....)),0,VLOOKUP(.....))
>
> --
> Biff
> Microsoft Excel MVP
>
>
> "B. Franklin Saunders" <B. Franklin Saunders(a)discussions.microsoft.com>
> wrote in message news:7C968092-F088-4077-8DEF-067504D84927(a)microsoft.com...
> > I'm using vlookup in excel to pull select data from a worksheet. The
> > problem
> > is that the value I'm seeking isn't always in the table array. So, I get
> > a
> > #n/a error. The #n/a then prevents me from summing the data that I'm
> > collecting using the vlookup. How do I make the #n/a go away or equal
> > zero
> > so I can sum the data?
>
>
>
 | 
Pages: 1
Prev: Linking data from one worksheet to another...
Next: Convert text entered as minutes/seconds to minutes