Cell Reference

[Gusher]

In cell b105 I have a number which is a variable. In cell b106 I wish to show the cell reference which is row one and whatever column number is in cell b105. So for example if cell b105 equals 26 then in cell b106 I wish to have the cell reference Z1 (because Z is the 26th column on the sheet). If b105 equals 1 then b106 equals A1 etc.

 

[Sanjeev1976]

Try :

=CHAR(64+B105)&"1"

 

[Aladin Akyurek]

In cell b105 I have a number which is a variable. In cell b106 I wish to show the cell reference which is row one and whatever column number is in cell b105. So for example if cell b105 equals 26 then in cell b106 I wish to have the cell reference Z1 (because Z is the 26th column on the sheet). If b105 equals 1 then b106 equals A1 etc.

One of:

=ADDRESS(1,B105,4)

=ADDRESS(1,B105)

 

[Gusher]

Thanks Aladin, that worked . Mark

 

[Gusher]

Thanks Sanjeev. This works but only as long as the number in b105 is 24 or below. Once you get past Z1 i.e AA1 formula does not work.

 

[Aladin Akyurek]

Thanks Aladin, that worked . Mark

You are welcome.