I am attemting the following formula in the spreadsheet, where AV1 has assumed the value passed on from the variable fPriorDate. I am receiveing an error. Do I still have to use the indirect method. Anyone?

vlookup(D2,'[AV1]30-Nov-2009_CDS'!$B$3:$D$175,3,False) = "divide", o2*vlookup(d2,'[AV1]30-Nov-2009_CDS'!$B$3:$D$175,2,False),o2/vlookup(d2,'[AV1]30-Nov-2009_CDS'!$B$3:$D$175,2,False))