Using VLOOKUP when referencing data from Access

A

asmithbcat

I currently have a pivot table which I have generated by using an Access
Database as an external data source. Also within this workbook on a seperate
sheet, I have a chart set up which graphs information based on date. I would
like to set up my source data for my chart so that once the pivot table is
refreshed, the source data is also refreshed by using a VLOOKUP to reference
the data from the pivot table by date. However, when I've tried this, I get
an error as if there is no value which matches. I would prefer to stay away
from pivot charts because of the formatting which has been done to the
charts, and I am familiar with vba. Any suggestions?
 
R

ryguy7272

I think this will work for you:
=IF(ISNA(YourFormula),0,YourFormula)

Regards,
Ryan---
 
A

asmithbcat

Thanks for your help. I used something similar to this, and there were also
some formatting differences from the access data to the excel data. I
appreciate the help.
 

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

Similar Threads

Creating a Chart on form from selected data in query. 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
PivotTable auto-refresh with external data 4
Can a pivot table be redirected to an external source? 1
Retain pivot table formatting after refreshing data 0
Pivot Table Mapping 1
How I can set dynamic pivot table ONLY when I have enough data point 1
VLOOKUP a Pivot Table Filter 0

Top