View Single Post
  #5   Report Post  
Harlan Grove
 
Posts: n/a
Default

"KL" wrote...
Try one of these:

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

....

The former is a MUCH BETTER idea than the latter since INDEX isn't usually
volatile, but INDIRECT always is. That means the INDEX call would only be
recalculated when some cell in the worksheet changes, but the INDIRECT call
would be recalculated every time Excel recalculated any other cells (in
other worksheets).