define a cell with the value of anothe cell
 

I'm very new to excel and i think i just don't understand a basic function
but i couldn't find it under the help menu.

how can you define a cell using a letter and then a value of another cell?
here is an example
W15=5
D5=10
my guess was =D(W15) which i would like to equal 10, but i get a name error

define a cell with the value of anothe cell
 

Hi Todd

Try
=INDIRECT("D"&W15)

--
Regards

Roger Govier



Todd Duncombe <Todd wrote:
I'm very new to excel and i think i just don't understand a basic
function but i couldn't find it under the help menu.

how can you define a cell using a letter and then a value of another
cell? here is an example
W15=5
D5=10
my guess was =D(W15) which i would like to equal 10, but i get a name
error