On Mon, 5 Sep 2005 06:33:03 -0700, "CC-Khriz"
wrote:
Hi all,
How can I use A1 = 1 and A2 = 2
then combine them so in A3 I have the contents of cell Row 1, column 2?
Your help would be much appreciated... CC
I'm interpreting this to mean that you have acvalue in cell B1 (Row 1
from A1, and Column B from A2), which you want returned in A3.
In which case the formula is
=INDIRECT(ADDRESS(A1,A2))
HTH
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
|