CODEWITHSUNDEEP
excelexcel-formulaexcel-2013
G. Sena
G. Sena

Reputation: 429

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?

Upvotes: 1

Views: 3108

Answers (2)

PeterH
PeterH

Reputation: 1040

USE

=INDIRECT("'tab 3x3'!"&ADDRESS(COLUMNS($A$7:E7)+5,7),TRUE)

Or in light of the comment from Scott, use

=OFFSET('tab 3x3'!$G$10,COLUMNS('tab 3x3'!$G$10:G10)-1,0)

Upvotes: 0

Scott Craner
Scott Craner

Reputation: 152525

Use INDEX:

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

Upvotes: 2

Related Questions