Importing Data Google Sheet to Google Sheet

Question

Sorry for all the nooby questions.

I have 2 spreadsheets:

• 1 contains all names and pay rates
• Another is a timesheet format

I basically need a formula on the timesheet spreadsheet that will look at the payrate spreadsheet and import the data across.

Example:

• Name Spreadsheet - (A1) Beth Hawkins (B1) £120
• 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

Is this even possible?

Thanks again!!!

Answer 1

You mentioned

Name Spreadsheet - (A1) Beth Hawkins (B1) £120

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

You can use the following formula in cell O9:

=IFERROR(VLOOKUP(C9,IMPORTRANGE("xxxxxxx","Name!A1:B"),2,0))

(where xxxxxxx is the Name Spreadsheet ID)

Functions used:

• IMPORTRANGE
• VLOOKUP
• IFERROR