=INDIRECT("'["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Priorsyeat" wrote in message
...
I am trying to access other excel files depending on a variable in my
current
worksheet
ie ='["Plan 200"&q5-1&" 200"&q5&".xls"]Main'!P36 such that when q5 is 6
then
the expression will be
='[Plan 2005 2006.xls]Main'!P36