Using a formula to select a cell using the row and column valu
You're welcome!
--
Biff
Microsoft Excel MVP
"RodneyN" wrote in message
...
Thank you
"T. Valko" wrote:
Try this:
=INDEX(A:A,C2)
If C2 is empty it will return the value from A1.
--
Biff
Microsoft Excel MVP
"RodneyN" wrote in message
...
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?
|