Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adjoining Cells
I have two worksheets in one spreadsheet. I want to be able to change 1
number and have the next cell down display the cell adjacent to the cell I input. For instance, if I specify Worksheet1 A1, I want the next cell down to display, Worksheet1 B1. Is this possible? If so, what is the formula or function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adjoining Cells
Use 2 cells, one to house the sheetname, another to house the cell ref
Input the sheetname in A1, eg: Sheet1 Input the cell ref in A2, eg: A1 Then place in say, A3: =OFFSET(INDIRECT("'"&A1&"'!"&A2),,1) A3 will return the required contents of Sheet1's B1 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Carla" wrote: I have two worksheets in one spreadsheet. I want to be able to change 1 number and have the next cell down display the cell adjacent to the cell I input. For instance, if I specify Worksheet1 A1, I want the next cell down to display, Worksheet1 B1. Is this possible? If so, what is the formula or function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula that compares data in adjoining cells | Excel Worksheet Functions | |||
How do I get the MAX value of adjoining columns then SUM range? | Excel Worksheet Functions | |||
3 criteria must exist in adjoining cells then rtn val from 4th | Excel Discussion (Misc queries) | |||
Search range of cells, find a value, output adjoining cell. How? | Excel Worksheet Functions | |||
How do I display contents of an adjoining cell? | Excel Worksheet Functions |