Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a Google Drive Calc File,

Google says in their web help how to reference data from another sheet, but what happens if what I need is to make the reference depending on my fields on the new sheet?

Ok, let me explain further... Let's say I have a sheet named 'My Data' and a Sheet named 'My List'. And on 'My List' I have a column where I'll place a number (let's say column A)

  • On Column A value: 15
  • On Column B value: 'My Data'

On column C of the same sheet instead of

='My Data'!B15

I want to have something like

='My Data'!B@ColumnA

Where @ColumnA is the number on column A. If it's possible, I have interest of doing this:


Is it possible?

share|improve this question

migrated from superuser.com May 26 '13 at 21:44

This question came from our site for computer enthusiasts and power users.

up vote 2 down vote accepted

You use INDIRECT().

=INDIRECT(B1 & "!" & A1)

I'm assuming that the values are in row 1 and that the value in Row B is surrounded by single quotes. Otherwise, you'll have to put them in.

=INDIRECT("'" & B1 & "'!" & A1)

The & concatenates the values. You could use the function CONCATENATE() instead.

[I put spaces for readability, but they're not needed.]

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.