Ask Your Question
0

Variable reference to a sheet name [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-20 22:13:35.350823

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

Question Tools

1 follower

Stats

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

Seen: 2,953 times

Last updated: Apr 29 '15