ExcelBanter - Data in cell to reference a worksheet page

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

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

- - Data in cell to reference a worksheet page (https://www.excelbanter.com/excel-worksheet-functions/60689-data-cell-reference-worksheet-page.html)

David Billigmeier

Data in cell to reference a worksheet page

=INDIRECT(A1&"!"&"B1")

--
Regards,
Dave

"eklarsen" wrote:

Column "a" has the name of the worksheet that I want reference.
I always want it to return the value on worksheet "Name" column B.

Is there a formula other then doing it manually ="Sheetname"!B1

--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: http://www.excelforum.com/member.php...fo&userid=9001
View this thread: http://www.excelforum.com/showthread...hreadid=493955

eklarsen

Data in cell to reference a worksheet page

Column "a" has the name of the worksheet that I want reference.
I always want it to return the value on worksheet "Name" column B.

Is there a formula other then doing it manually ="Sheetname"!B1

--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: http://www.excelforum.com/member.php...fo&userid=9001
View this thread: http://www.excelforum.com/showthread...hreadid=493955

eklarsen

Data in cell to reference a worksheet page

Worked great, thanks

--
eklarsen
------------------------------------------------------------------------
eklarsen's Profile: http://www.excelforum.com/member.php...fo&userid=9001
View this thread: http://www.excelforum.com/showthread...hreadid=493955

All times are GMT +1. The time now is 03:34 PM.