Search code examples
excelexcel-formulaexcel-2013

How to fill formula horizontally but increment cell references vertically

I need to populate a table with horizontally referring to values that are vertically from another table

In the horizontal table I'm doing the following

='Tab 3x3'!G10

But when I drag to the side it increments the column, not the cell. It would need him to continue G11, G12 .. and so on.

I've tried to anchor ($) in every way but it's no use. I also tried using TRANSPOSE that even worked but it got a mess, I would need the same reference as the above formula. I also researched and found a staff using Offset, but I could not quite understand.

Any easy way to do this?

Solution

  • Use INDEX:

    =INDEX('Tab 3x3'!$G:$G,COLUMN(A:A)+9)