define a cell with the value of anothe cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Todd Duncombe - 03 Jan 2006 00:06 GMT

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

Reply to this Message

Roger Govier - 03 Jan 2006 00:13 GMT

Hi Todd

Try
=INDIRECT("D"&W15)

Signature

Regards

Roger Govier

> 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.
[quoted text clipped - 5 lines]
> my guess was =D(W15) which i would like to equal 10, but i get a name
> error

Reply to this Message