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?