| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How create a formula series with series inside
If the other files are going to be open you should look at the INDIRECT
function. FYI - replace =+ with just = and replace " " with "" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Ric" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How create a formula series with series inside
Thank you Shane, could you please tell me what is the INDIRECT function and
how i can use? thank you again... "Shane Devenshire" wrote: If the other files are going to be open you should look at the INDIRECT function. FYI - replace =+ with just = and replace " " with "" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Ric" wrote: 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How create a formula series with series inside
Returns the reference specified by a text string. References are immediately
evaluated to display their contents. Use INDIRECT when you want to change the reference to a cell within a formula without changing the formula itself. Here is the general way to make the sheet name (in your case a number) a variable: Say we have the formula: =Sheet2!A1 but we want to use a cell reference rather than the hard-coded Sheet2. Use instead: =INDIRECT(B2 & "!A1") and put Sheet2 in cell B2 If your sheetname has spaces then =INDIRECT("'" & B2 & "'!A1") If this post helps click Yes --------------- Jacob Skaria "Ric" wrote: Thank you Shane, could you please tell me what is the INDIRECT function and how i can use? thank you again... "Shane Devenshire" wrote: If the other files are going to be open you should look at the INDIRECT function. FYI - replace =+ with just = and replace " " with "" -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Ric" wrote: 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. |
| Reply |
| 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 | |||
Linear Mode
