| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How create a formula series with series inside
I have this formula:
=+IF(VLOOKUP($C1,'C:\Documents and Settings\ricardo\My Documents\DPR-Ajax\[2005-01.xlsx]Data Presence Report.rdl'!$B$5:$J$89,4,0)=0," ",VLOOKUP($C1,'C:\Documents and Settings\ricardo\My Documents\DPR-Ajax\[2005-01.xlsx]Data Presence Report.rdl'!$B$5:$J$89,4,0)), and i want to use this formula along of a worksheet, but i need to change the table_array creating a new sweries like: =+IF(VLOOKUP($C1,'C:\Documents and Settings\ricardo\My Documents\DPR-Ajax\[2005-02.xlsx]Data Presence Report.rdl'!$B$5:$J$89,4,0)=0," ",VLOOKUP($C1,'C:\Documents and Settings\ricardo\My Documents\DPR-Ajax\[2005-02.xlsx]Data Presence Report.rdl'!$B$5:$J$89,4,0)), then, in each new colum change the table_array name, increasing as 2005-03,2005-04,2005-05, etc. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
| Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
| Is it possible to filter the data inside the series command? | Charts and Charting in Excel | |||
| chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
| series graph -- one series being added to another series | Charts and Charting in Excel | |||
Threaded Mode
