View Single Post
  #5   Report Post  
Richard Buttrey
 
Posts: n/a
Default

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
__________________________