View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier
 
Posts: n/a
Default 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