HOW DO I REFERENCE A CELL FROM THE RESULTS OF TWO WORKSHEETS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a matrix on sheet 1 with columns and rows. On Sheet 2 I identify
which row I need to use on sheet 1. On Sheet 3 I identify which column I need
to use on sheet 1. How do I combine these two result to reference a specific
cell of the matrix on sheet 1. All I can get it to show is the name of the
cell I want and not the value in the cell I want.

Thanks

TD
 
You must log in or register to reply here.

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

Code to format cells on several worksheets 2
Blank Cell Reference, without if statement 4
Remove date format? 3
Resolve a text cell reference to the cell's value 3
Compound Reference 2
Excel Is this possible?? 3
variable sheet name 6
Excel Columns moving up and down on their own in a worksheet. What Goes? 2

Back
Top