#N/A - Excel

  • Thread starter Thread starter Paul
  • Start date Start date
P

Paul

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
 
Paul said:
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
Click to expand...

Your formula will be of the form
=VLOOKUP(...)
Wrap this within an IF statement, like this:
=IF(ISNA(VLOOKUP(...),"",VLOOKUP(...)))
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.
 
Back
Top