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