JE McGimpsey

Posts: n/a

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!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return Count for LAST NonBlank Cell in each Row	Sam via OfficeKB.com	Excel Worksheet Functions	12	April 17th 05 10:36 PM
Sheet Modified date in a cell.. ?	n666	Excel Worksheet Functions	0	February 16th 05 01:32 AM
formula to return the value of a cell based on a looked up true reference	sarah	Excel Worksheet Functions	2	February 2nd 05 08:15 PM
I want cell entry to be identical on another sheet	NIMDRA	Excel Worksheet Functions	1	January 10th 05 04:01 AM
GET.CELL	Biff	Excel Worksheet Functions	2	November 24th 04 07:16 PM

All times are GMT +1. The time now is 04:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us