ExcelBanter - return cell from named sheet

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - return cell from named sheet (https://www.excelbanter.com/excel-discussion-misc-queries/22395-return-cell-named-sheet.html)

AndrewB

return cell from named sheet

Hi,
I have a list of sheet names in column A and want to return the value of the
repective sheets cell E10 in column B.

Many thanks in advance!

JE McGimpsey

One way:

B1: =INDIRECT("'" & A1 & "'!E10")

In article ,
"AndrewB" wrote:

Hi,
I have a list of sheet names in column A and want to return the value of the
repective sheets cell E10 in column B.

Many thanks in advance!

All times are GMT +1. The time now is 07:52 PM.