Use reserved word to specify current worksheet name

[decdec]

In the following statement i would like to replace the month name September
2008 with a word that would say use current worksheet name. (ie. sort of like
how Column() and Row() work, but with a worksheet name. Of course just as
soon as i learn how to do this, i'll want to do the same with the workbook
name.

=IF(ISNA(VLOOKUP($A40,'F:\BILLING\[2008 Error ReportN.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(ISNUMBER(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportN.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE)),VLOOKUP($A40,'F:\BILLING\[2008 Error
ReportN.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE),0))+IF(ISNA(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportS.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(ISNUMBER(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportS.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE)),VLOOKUP($A40,'F:\BILLING\[2008 Error
ReportS.xlsx]September 2008'!$A$3:$J$70,COLUMN(),FALSE),0))

 

[Jim Thomlinson]

Since you are in the programming forum I assume you are doing this in code???
So something like this...

=IF(ISNA(VLOOKUP($A40,'F:\BILLING\[2008 Error ReportN.xlsx]September
2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(ISNUMBER(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportN.xlsx]" & activesheet.name & "
2008'!$A$3:$J$70,COLUMN(),FALSE)),VLOOKUP($A40,'F:\BILLING\[2008 Error
ReportN.xlsx]" & activesheet.name & "
2008'!$A$3:$J$70,COLUMN(),FALSE),0))+IF(ISNA(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportS.xlsx]" & activesheet.name & "
2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(ISNUMBER(VLOOKUP($A40,'F:\BILLING\[2008
Error ReportS.xlsx]" & activesheet.name & "
2008'!$A$3:$J$70,COLUMN(),FALSE)),VLOOKUP($A40,'F:\BILLING\[2008 Error
ReportS.xlsx]" & activesheet.name & " 2008'!$A$3:$J$70,COLUMN(),FALSE),0))