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