#N/A - Excel

Giganews Newsgroups
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?

Thanks

Replies