#N/A - Excel

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
 
P

Paul

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top