| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLOOKUP referencing a cell with a URL | Excel Worksheet Functions | |||
| VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) | |||
| Series referencing a document that I have no access to | Charts and Charting in Excel | |||
| How do I access data stored in a SQL server for vlookup function? | Excel Worksheet Functions | |||
| vlookup function in excel referencing an access table | Excel Worksheet Functions | |||
Linear Mode
