Ask Your Question
0

Variable reference to a sheet name

asked 2015-04-29 11:49:42 +0100

orschiro gravatar image

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!

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-04-29 12:39:51 +0100

karolus gravatar image

Try with:

=INDIRECT($A2 & ".D19")

and pull down.

edit flag offensive delete link more

Comments

Hi karolus, This only returns 0.00, unfortunately.

orschiro gravatar imageorschiro ( 2015-04-29 17:25:24 +0100 )edit

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

karolus gravatar imagekarolus ( 2015-04-29 18:16:02 +0100 )edit

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

orschiro gravatar imageorschiro ( 2015-04-29 21:28:54 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-04-29 11:49:42 +0100

Seen: 2,360 times

Last updated: Apr 29 '15