ExcelBanter - creating cell references

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - creating cell references (https://www.excelbanter.com/excel-discussion-misc-queries/117358-creating-cell-references.html)

[email protected]

creating cell references

A1 contains a number like 13.
Let's say I want a cell to contain what is in cell O13.
How do I create a reference such that the column is "O" and the row
number comes from the contents of A1?
Something like =O(A1)

would return what is in O13.

Earl Kiosterud

creating cell references

=INDIRECT("O"&A1)

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
ups.com...
A1 contains a number like 13.
Let's say I want a cell to contain what is in cell O13.
How do I create a reference such that the column is "O" and the row
number comes from the contents of A1?
Something like =O(A1)

would return what is in O13.

[email protected]

creating cell references

Earl Kiosterud wrote:
=INDIRECT("O"&A1)

--
Earl Kiosterud
www.smokeylake.com

I could kiss you. Thanks!

Earl Kiosterud

creating cell references

A woman said that to me once. I said "I'm game." So she shot me.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
wrote in message
oups.com...

Earl Kiosterud wrote:
=INDIRECT("O"&A1)

--
Earl Kiosterud
www.smokeylake.com

I could kiss you. Thanks!

All times are GMT +1. The time now is 05:03 AM.