I've a Google Spreadsheet where my first sheet is a Products table. The columns are SKU, Title, Price, Category, Type

I've some tasks in front of me where I need to create some bundles of different products. These varieres in number of products and categories and types.

I don't know if this is possible with the Spreadsheet app or I have to find alternative methods but I would love if I could reference e.g. the SKU number or the Title instead of my Sheet cell.

So, in a new sheet called Bundle 01: Texture instead of saying =Products!A4 I somehow reference =Products!SKU015 and then the entire row from Products is inserted.
I can make calculations and aggregates on the price/total price and other variables and should I change a Product row in **Products sheet* it will automatically update across all sheets in that spreadsheet.

Beside the benefits listed above it would also create an easy and quick overview of each bundle, both for myself but also for other actors which have interest in these.

The closets I've come to using data across one spreadsheet is https://support.google.com/docs/answer/75943 but this is just a reference to the cell.

Any help is deeply appreciated.

  • What's SKU015 ? Try INDEX/MATCH – TheMaster Mar 11 '18 at 21:38
  • SKU015 was just an example of what I would like to reference instead of a cell number. The is just a product-ID which sits in the first column of my products sheet. I'll look into INDEX/MATCH and see what these guys are up to - thanks :) – Mestika Mar 12 '18 at 4:11

It seems that the OP (Mestika) was needing named ranges.

  • good answers quote from a link so that if the link rots the answer is still good. – mhoran_psprep Oct 14 '18 at 12:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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