| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Use reserved word to specify current worksheet name
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(IS NUMBER(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(VLOOK UP($A40,'F:\BILLING\[2008 Error ReportS.xlsx]September 2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(IS NUMBER(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)) -- Dec |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Use reserved word to specify current worksheet name
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(IS NUMBER(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(VLOOK UP($A40,'F:\BILLING\[2008 Error ReportS.xlsx]" & activesheet.name & " 2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(IS NUMBER(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)) -- HTH... Jim Thomlinson "decdec" wrote: 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(IS NUMBER(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(VLOOK UP($A40,'F:\BILLING\[2008 Error ReportS.xlsx]September 2008'!$A$3:$J$70,COLUMN(),FALSE)),8881000000,IF(IS NUMBER(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)) -- Dec |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| what is a worksheet reserved name? | Excel Discussion (Misc queries) | |||
| Ascertaining whether a search in VBA code returns a string or a reserved word | Excel Programming | |||
| time between table in word and current date | Excel Programming | |||
| Renaming Worksheet: Error message: "Reserved Name" | Excel Discussion (Misc queries) | |||
| I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
Linear Mode
