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.
|