ExcelBanter - Adjoining Cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Adjoining Cells (https://www.excelbanter.com/excel-worksheet-functions/169204-adjoining-cells.html)

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?

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?