I am going to assume you are still in the wrong forum. You want a formula
that uses teh tab name of the corrent sheet to access a cell from the same
tab name in another workbook??? Am I close???

Here is a formula that will get you the tab name
=MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255)

You will need to use a variation of the indirect function as indirect can
not operat on a closed workbook...

You can download an add-in called Morefunc it has a function called
INDIRECT.EXT
that will work if the source book is closed

http://xcell05.free.fr/morefunc/english/index.htm


there is no built in function that can take a string referring to another
workbook that is not open and make it into a valid formula

--
HTH...

Jim Thomlinson


"decdec" wrote:

Hope i'm in right forum this time.

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