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.