Try =INDEX(INDIRECT("'[012007 Cash.xls]"&$G$4&"'!$T$150:$T$354",$C7+1-150,1)


--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"JMay" wrote in message
...

at present this formula is sucessful:

in cell G7 I have:
=INDEX('[012007 Cash.xls]Day4'!$T$150:$T$354,$C7+1-150,1)

In Cell G4 I have text Day4

How can I alter my formula to read the G4 value in place of the hard-coded
Value?
something like ,,,,

=INDEX('[012007 Cash.xls] Indirect($G$4) '!$T$150:$T$354,$C7+1-150,1)
??
Any help appreciated..