View Single Post
  #2   Report Post  
KL
 
Posts: n/a
Default

Hi,

Try one of these:

=INDEX(1:65536,A1,A2)
=INDIRECT(ADDRESS(A1,A2))

Regards,
KL


"CC-Khriz" wrote in message
...
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