Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding actual Cells
Hello! I would like to add actual cells, and not their values...
example : in $A$1 I have 1 in $A$2 I have 1 in $C$1 I would like to write an equivalent to this : =$A$(1+1) OR, can I replace the A or 1 of my $A$1 with a variable to be able to retrieve certain info? For example : $A$1 = 1 $B$1 = Company name $B$2 = Address $B$3 = Phone number then in another sheet, I use a pull down menu to retrieve this information: When 1 is selected, I get the info from ($B$[var]) thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding actual Cells
"Ninjapowa" wrote in message
... Hello! I would like to add actual cells, and not their values... example : in $A$1 I have 1 in $A$2 I have 1 in $C$1 I would like to write an equivalent to this : =$A$(1+1) OR, can I replace the A or 1 of my $A$1 with a variable to be able to retrieve certain info? For example : $A$1 = 1 $B$1 = Company name $B$2 = Address $B$3 = Phone number then in another sheet, I use a pull down menu to retrieve this information: When 1 is selected, I get the info from ($B$[var]) thanks! Look up the OFFSET and INDIRECT functions in Excel's help, & see whether one of those will do the job for you. -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Adding cells witht the same name | Excel Discussion (Misc queries) | |||
Adding up multiple cells | Excel Worksheet Functions | |||
adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. | Excel Discussion (Misc queries) |