Thread: Using a formula to select a cell using the row and column values
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Using a formula to select a cell using the row and column values
My intuition tells me that INDIRECT is what you are looking for
In D1: =INDIRECT("A"&C2)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik
---
"RodneyN" wrote:
With a value in cell C2 of 1. Can't I use a formula in cell D1 that says
let D1 equal the contents of cell A(c2). So D1 will equal the value of cell
A1? Or if c2 equaled a value of 4 then D1 would be equal to the value of
cell A4?
Reply With QuoteReply With Quote