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've been trying to work out how to copy data from cells on a worksheet into another based upon the value in a cell.

We have weekly data so for arguments sake

Week 1     Week 2     Week 3     Week 4

   1         5          3          2

  $10       $90        $75        $15

What I'd like to be able to do, is input the overall worksheet with Week 1 and it automatically drags 1 and 10 into cells from the data worksheet.

I've been trying to make lookup address & vlookup work, but neither appear to do what I'd like them to... I'm using Google Docs if that makes any difference?

share|improve this question
Perhaps you can share a doc with us or show us the outcome in a second table? – Jacob Jan Tuinstra Jul 3 '13 at 5:45

If Week 1 is in A1 of both sheets, 1 is in A2 of a worksheet etc then this might suit in B1 of another:


copied across to C1 and the 2 there replaced by 3.

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.