title: Importing Data Google Sheet to Google Sheet
body: <p>Sorry for all the nooby questions.</p>
  <p>I have 2 spreadsheets:</p>
  <ul>
  <li>1 contains all names and pay rates</li>
  <li>Another is a timesheet format</li>
  </ul>
  <p>I basically need a formula on the timesheet spreadsheet that will look at the payrate spreadsheet and import the data across.</p>
  <p>Example:</p>
  <ul>
  <li>Name Spreadsheet - (A1) Beth Hawkins (B1) £120</li>
  <li>Timesheet Spreadsheet - the name Beth Hawkins is inputted into cell C9, I need a formula in cell O9 to then go into the name spreadsheet and find the payrate that Beth is on, and automatically input that when the name is typed</li>
  </ul>
  <p>Is this even possible?</p>
  <p>Thanks again!!!</p>