I'm trying to import columns of data from different sheets. Examples:
SEARS -- (sheet one) (I'm entering the prices manually) 1/2013 $8 2/2013 $5 3/2013 $14
Here is sheet two: (I'm entering the prices manually)
TARGET 1/2013 $7 2/2013 $10 3/2013 $4
Here is the resulting sheet (to be imported automatically from the other 2 sheets).
TOTALS SEARS TARGET 1/2013 $8 $7 2/2013 $5 $10 3/2013 $14 $4
I'm not sure how to do this. I think that for the resulting sheet I could use the VLOOKUP function to look for a date value in each sheet. Something like:
=VLOOKUP (1/2013, 'TARGET_SHEET'|B1:C3,1).
This produces the desired result for the cell, but ideally I would want a way to clone this formula to all the rows and columns on the result sheet so I don't need to fill it out manually for each cell.
Anyone have an idea about how to do this?
I am using the NEW Google sheets, by the way.