1

This question already has an answer here:

We use Google Sheets for tech commission sheets (track jobs and hours). Right now we have 2 years (2017&2018) in 1 set of sheets, 1 sheet for each month (jan 17, feb 17, etc). So instead of adding more sheets, I would like to just create a new set of sheets for 2019 but I need to be able to pull/search for data from the 2017/2018 sheets to ensure a tech doesn't accidentally pay themselves for a job twice.

Is this possible? And if yes, how can I do it?

marked as duplicate by ale, serenesat, Rubén google-sheets Oct 7 at 21:02

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

0

=QUERY(IMPORTRANGE("1GOvESQ3lPEZbHeU4pPNGWDBznqqLRh3ly7Xt3r-q2vY",B1&"!"&B2), B3, 1)

c

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