Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Using Name Label to try to define linked cell | Links and Linking in Excel | |||
GET.CELL | Excel Worksheet Functions |