Using VLOOKUP when referencing data from Access
I think this will work for you:
=IF(ISNA(YourFormula),0,YourFormula)
Regards,
Ryan---
--
RyGuy
"asmithbcat" wrote:
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?
|