Variable reference to a sheet name

[orschiro]

Example:

Column 1 | Column 2
19		 | ='19'.D19

In column 2 I reference to a sheet with the name 19. How can I make this reference to a sheet name variable based on the id in column 1?

For example, the next row could contain another ID for which I want to automatically reference to.

26        | ='$A3'.D19

The cell containing 26, in this case, is the cell A3.

Thanks!

[karolus]

Try with:

=INDIRECT($A2 & ".D19")    

and pull down.

[orschiro]

Hi karolus, This only returns 0.00, unfortunately.

[karolus]

Unfortunately - nobody can look over your Shoulder – Please attach some Example.ods

[orschiro]

Stupid typing error on my side. Sorry! Your solution does work perfectly.