Using VLOOKUP when referencing data from Access

[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?

 

[ryguy7272]

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

Regards,
Ryan---

 

[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.