earlier at

http://www.microsoft.com/office/comm...8-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?

=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


--

Regards,

Peo Sjoblom






"i2meek" wrote in message
...
earlier at

http://www.microsoft.com/office/comm...8-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?