reference inside worksheet function

[pls123]

hi all !! i need a function like this next one ...

='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999

....but with A16 value instead of 999...
can anybody help..
tx
paolo

 

[tompl]

Try this:

=INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$†& A1)

Tom

 

[tompl]

Try this:

=INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$†& A16)

Tom

 

[pls123]

i think you told it !!
thank you tompl i was losing a lot of afternoon !

paolo

Try this:

=INDIRECT(“'[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$†& A1)

Tom

hi all !! i need a function like this next one ...

='[@@@@PLT@@@@MI.UCG.xlsm]Sheet1'!$D$999

...but with A16 value instead of 999...
can anybody help..
tx
paolo