Incremental Rows

Hi,

I have what seems quite a simple problem.

In Cell C7 of my sheet I have this formula returning a value from a PIVOT table in another sheet: =UPPER('UNI Pivot'!A6)

As I drag this across the columns (to form headings) I would like the rows to increase in the formula so it looks like:

=UPPER('UNI Pivot'!A6)
=UPPER('UNI Pivot'!A7)
=UPPER('UNI Pivot'!A8)
=UPPER('UNI Pivot'!A9)

And so on...

However, at the moment when I do it it simply increases the Column so I get: B6, C6, D6.

Is there something I can add to this formula to do this?

Thanks for help in advance.

Try
=UPPER(INDIRECT("'UNI Pivot'!A"&COLUMN()-1))

Note double quotes after 2md opening bracket and also after the letter A in the formula

Try it like this...

=UPPER(INDEX('UNI Pivot'!$A6:$A20,COLUMNS($C7:C7)))

Adjust for the correct end of range where I use down to A20.

You're welcome. Thanks for the feedback!