paste-link fill right

[i2meek]

earlier at

http://www.microsoft.com/office/com...misc&mid=fb15f05f-9139-47bd-ad18-2260e597da2f

i was instructed how to paste-link and fill down using the "INDIRECT"
function. Now I need to fill to the right. I need to have this formula:

=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!E4")

in a row and then fill to the right having the E4 go to F4, then G4, H4 ...
How can I do this?

 

[Peo Sjoblom]

=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!"&CELL("address",E4))

or

=INDIRECT("'[Data.xlsx]Game " & $Z2 & "'!"&CELL("address",E$4))

if you want to anchor the 4th row