Using the results from two seperate cells to create cell reference

D

DarrenWood

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
other formula's.

In other words on my main sheet one formula would result in th
worksheets name, another will refer to the column ref and another wil
refer to the row ref. I can get these results but I cant seem to the
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

Thank
 
A

Aladin Akyurek

=INDIRECT("'"&A5&"'!"&A6&A7)
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
other formula's.

In other words on my main sheet one formula would result in th
worksheets name, another will refer to the column ref and another wil
refer to the row ref. I can get these results but I cant seem to the
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

Thank
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
Use Formula from another worksheet 3
Referencing formula using Indirect 4
add two cells from seperate work sheets into a cell on seperate wo 6
Sum of cells, where there are not errors in them 8
Excel VBA 1
how do i use IF to substitute for another cell? 1
cell reference 3

Top