To extend the formula below to a new column each month without having to modify it, how would it be rewritten to incorporate the month and year from J$1 instead of referencing 07-02? J1 contains 07-31-02 as a serial number.
=IF(ISERROR(VLOOKUP($A34,'G:Zones[07-02 ME Investor Trial Balance.xls]Trial Balance Report For'!$A$11:$L$500,12,FALSE)),"",VLOOKUP($A34,'G:Zones[07-02 ME Investor Trial Balance.xls]Trial Balance Report For'!$A$11:$L$500,12,FALSE))
=IF(ISERROR(VLOOKUP($A34,'G:Zones[07-02 ME Investor Trial Balance.xls]Trial Balance Report For'!$A$11:$L$500,12,FALSE)),"",VLOOKUP($A34,'G:Zones[07-02 ME Investor Trial Balance.xls]Trial Balance Report For'!$A$11:$L$500,12,FALSE))