|Subject:||Re: #N/A - Excel|
|Posted by:||Paul (none)|
|Date:||Mon, 6 Oct 2003|
"Paul" <pjagga…@aco.co.uk> 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?
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.
#N/A - Excel posted by Paul on Mon, 6 Oct 2003