Using VLOOKUP when referencing data from Access
 

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?

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?

Using VLOOKUP when referencing data from Access
 

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.

"ryguy7272" wrote:

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?