|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 3rd, 2006, 12:06 AM
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
January 3rd, 2006, 12:13 AM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Dates of a Day for a month & year cell formulas | mikeburg | General Discussion | 2 | December 29th, 2005 10:14 PM |
| Possible Lookup Table | Karen | Worksheet Functions | 5 | June 8th, 2005 09:43 PM |
| GET.CELL | Biff | Worksheet Functions | 2 | November 24th, 2004 07:16 PM |
| IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |
| Do you have what it takes... | Frank Kabel | Worksheet Functions | 1 | February 22nd, 2004 08:30 PM |
Linear Mode
