Relative Reference of Colomns in Rows

[Please_H]

Hi,

I would like to dragdown the below data which have been typed in Z1, Z2, Z3 cells respectively and get it relatively increasing...

#Sheet1!A1
#Sheet1!C1
#Sheet1!E1

Can someone please help me?

Thanks alot...

 

[lrobbo314]

How about this...

=OFFSET(Sheet1!$A$1,0,ROW()-2+ROW())

 

[Please_H]

No brother, it didn't Work...

 

[lrobbo314]

Seems to be working for me. I pasted the formula in Z1 and it's incrementing the way you describe. Are you trying to return what is actually in those cells, or are you trying to return the cell references themselves?

 

[footoo]

If you just need the text per post #1 , put in Z1 :

="#Sheet1!" & CHAR(64+(ROW()*2)-1) & 1

 

[Please_H]

What you have done also could be helpful...

Problem here is, I have literally typed "#Sheet1!A1" in Z1, then "#Sheet1!C1" in Z2, when I select both Z1 & Z2 then drag it down the references which have been typed doesn't relatively increase...

Or,

To make things easier,

Is there anyway to get "A1" as data in Cell A1 via formula?

 

[Please_H]

Wait a minute...wait a minute...

Wow...

That is exactly what I wanted...now do me a favor please...

My actual references should be F15, H15, J15...so on...now how can I customize your equation brother?

 

[footoo]

.

 

[Please_H]

Footoo's solution worked...now trying to customize it bro...

 

[footoo]

Enter in Z1 :

="#Sheet1!" & CHAR(69+(ROW()*2)-1) & 1