I recently received help on creating a formula to fill in data on a Google sheet for customer orders, this goes between sheet1 (master) and sheet2 (selected data only, depending on the reference cell).

The reference cell is a drop down, I then entered the range from sheet1.

The areas collecting data have this formula; =iferror( vlookup($H$14, ORDERS!$A$2:$Z, column(ORDERS!$E:$E), false) ) and I change the column() accordingly - this works perfectly.

However, I have one area that requires an offset to cater for multiple products in the same column but the next row. How would I change the above formula to get this to offset to the cell below?

1 Answer 1


Use offset(), like this:

=iferror( offset( vlookup($H$14, ORDERS!$A$2:$Z, column(ORDERS!$E:$E), false), 1, 0 ) )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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