user outlaw26r said: (http://productforums.google.com/forum/?zx=knoiadu3x64v#!category-topic/docs/spreadsheets/uOqfBZWhqFY%5B1-25%5D)
import range cell if it matches project number from another sheet
I am creating a project cover sheet document that I would like to pull data from various Google spreadsheets so the project team can get a good quick feel for the project status. My goal is that when I begin a new project, I am able to type in the unique project number and have it auto populate from various sources.
following is a solution to the problem
here is an image of Project Master Spreadsheet