Look in HELP for the INDIRECT() function

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"ParTeeGolfer" wrote in message
...
Ihave the following formula which does work, however I would like to
modify
so I can insert lines and not have to retype portions of this formula.

=IF($A47="","",VLOOKUP($W$5,'C:\Travel Basketball\[2004 Rush Offensive
Stats.xls]Game 38'!$B$2:$AH$17,11,FALSE))

I would like to have somethink like:

=IF($A47="","",VLOOKUP($W$5,'C:\Travel Basketball\[2004 Rush Offensive
Stats.xls]$B47!$B$2:$AH$17,11,FALSE))

but I get an error with this formula

$B47 is in the workbook that I am currently working on (or opened) and
Rush
Offensive Stats is not opened. I know this can be done with an indirect
command however I am trying to prevent the indirect.

With the top formula, Rush Offensive Stats does not have to be opened
however the worksheet is named directly(GAME 38)

I need to have this as a variable

PLEASE HELP!