So I need to find the formula to pull a column out of one page of my Google Docs spreadsheet and insert it into a separate workbook.

Here are some more details: all rows from column C (part number) from sheet 2, workbook 1 and insert it into sheet 1 of workbook 2 (under column C "part number").


1 Answer 1


This Formula gives you the perfect solution:


Write this formula in the "C3" of your "workbook 2,sheet 1".

  • funny, because I deff tried to work that formula ... Iguess there was something that I missed. Thanks for your help! Dec 14, 2013 at 20:35
  • hey @karthik I have another question if you have the time. Here is the link for its posting Dec 14, 2013 at 22:40

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