New to Google sheets, so feel like I'm falling down somewhat of a rabbit hole trying to figure this out...
I have a spreadsheet 'sheet 1' where we keep the details of our sales - Name, address, design, size, tracking.
Then we have
'sheet 2' set up as a job requirement sheet, this gathers the data to be sent to the manufacturer - like a receipt. But, we only need certain info and only from one row at a time.
I can create the reference cell in
sheet2, say I select cell
F13 ( where I want my order number ) and type
='sheet 1'!A131, this gives me the order number from sheet1.
What I would like to do then, is have the other chosen cells change depending on that reference cell.
I have each required information cell with a series of these formulas;
=OFFSET('sheet1'!A131, 0, 6, 1, 1), which works...but means every time I change the reference I need to update all of the formulas manually to match the original reference ( say
A131 changes to
I can't use
=OFFSET(F13, 0, 6, 1, 1), for obvious reasons it doesn't take into account the formula address from
Is there a way to get this to work across 2 sheets? I haven't found a way to do it by searching Google, other than the below - but alas I can't understand how to get it to work, kept getting errors.