Re: #N/A - Excel

Giganews Newsgroups
Subject: Re: #N/A - Excel
Posted by:  Paul (none)
Date: Mon, 6 Oct 2003

"Paul" <pjagga…> wrote in message
> When VLOOKUP ing from a database to retrieve info from a
> pivot table I keep getting many #N/A errors as there is no
> data in the pivot table.
> I have tried to suppress it with ERROR.TYPE and IF
> statements but no joy.
> Can anyone advise another formula?
> Thanks

Your formula will be of the form
Wrap this within an IF statement, like this:
This will show nothing if there is no data available. You could replace ""
by your own error message such as "data not available" if you prefer.



In response to

#N/A - Excel posted by Paul on Mon, 6 Oct 2003