Remember Me?

#1
November 14th 04, 09:24 PM
 DarrenWood Posts: n/a
Using the results from two seperate cells to create cell reference

I want to be able to obtain the value of a cell in another worksheet,
however I want to be able to name that cell by using the results from 3
other formula's.

In other words on my main sheet one formula would result in the
worksheets name, another will refer to the column ref and another will
refer to the row ref. I can get these results but I cant seem to then
type a formula to retrive the data from the resultant cell ref

eg 3 formulas result in
a5 = sheet 3
a6 = C
A7 = 6

then cell d1 needs to show the value of cell C6 in worksheet 3

It sounds possible but i just cant work it out

Thanks

--
DarrenWood
------------------------------------------------------------------------
DarrenWood's Profile: http://www.excelforum.com/member.php...o&userid=16460

#2
November 14th 04, 09:35 PM
 Frank Kabel Posts: n/a

Hi
try
=INDIRECT("'" & A5 & "'!" & A6 & A7)

--
Regards
Frank Kabel
Frankfurt, Germany

DarrenWood wrote:
I want to be able to obtain the value of a cell in another worksheet,
however I want to be able to name that cell by using the results from
3 other formula's.

In other words on my main sheet one formula would result in the
worksheets name, another will refer to the column ref and another

will
refer to the row ref. I can get these results but I cant seem to then
type a formula to retrive the data from the resultant cell ref

eg 3 formulas result in
a5 = sheet 3
a6 = C
A7 = 6

then cell d1 needs to show the value of cell C6 in worksheet 3

It sounds possible but i just cant work it out

Thanks

#3
November 14th 04, 10:35 PM

=INDIRECT("'"&A5&"'!"&A6&A7)

DarrenWood Wrote:
I want to be able to obtain the value of a cell in another worksheet,
however I want to be able to name that cell by using the results from 3
other formula's.

In other words on my main sheet one formula would result in the
worksheets name, another will refer to the column ref and another will
refer to the row ref. I can get these results but I cant seem to then
type a formula to retrive the data from the resultant cell ref

eg 3 formulas result in
a5 = sheet 3
a6 = C
A7 = 6

then cell d1 needs to show the value of cell C6 in worksheet 3

It sounds possible but i just cant work it out

Thanks

--
------------------------------------------------------------------------

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

 Similar Threads Thread Thread Starter Forum Replies Last Post jobby55 Excel Discussion (Misc queries) 2 January 13th 05 05:00 AM Nick M Charts and Charting in Excel 1 December 15th 04 03:50 AM TD Excel Discussion (Misc queries) 1 December 14th 04 03:16 PM TD Excel Discussion (Misc queries) 0 December 14th 04 02:25 AM GRITS Excel Discussion (Misc queries) 1 December 2nd 04 08:30 PM

All times are GMT +1. The time now is 10:30 AM.

The comments are property of their posters.