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...

 

[Please_H]

yes yes yes !!!!! Footoo has been my life saver...

Daiiiiiiiiiiiiiiiiiiiiiiiiiiiinnnnnggggggggg you guys are smart...

I am sure in near futute you guys will even crack a way to turn Air to a Pizza...lol...

Thank you Irobbo314 too for your immense support and taking your valuable time off to help me out...

Bless you both...

Cheers.

Tc.

P.S - I changed the Char No. to 69 and last number to 15... it was Magicallllll... !!!

 

[Please_H]

Seems still we have a problem :/

As I drag down after the letter V, then Z...symbols starts to kick in instead of AA, AC...etc...

Any solution to that Brother?

 

[Please_H]

As I drag down symbols kick in and then it goes into an error cell...

 

[footoo]

="#Sheet1!" & SUBSTITUTE(ADDRESS(1,6+(ROW()*2),4),1,"") & 15

 

[Please_H]

Thanks a lot Bro...you've done it again...Great...

 

[footoo]

To return “#Sheet1!H15” in any starting cell, let’s say cell E10, put this in E10 :
=IFERROR("#Sheet1!" & SUBSTITUTE(ADDRESS(1,COLUMN(H$1)+(ROW()*2)-ROW(E$10)*2,4),1,"") & 15,"")
This formula can be dragged down or up.

If a cell ref other than H15 needs to be returned in the starting cell, then change the characters highlighted in red :
=IFERROR("#Sheet1!" & SUBSTITUTE(ADDRESS(1,COLUMN(H$1)+(ROW()*2)-ROW(E$10)*2,4),1,"") & 15,"")

 

[Please_H]

Wow...Nice...

Great info Bro...

Screeshot is taken right away and saved for future reference...

Hugssss.... !!!!!