Formula to locate a cell

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

Guest

I need to se if there is a formula to return a specific cell on a worksheet
but the worksheet name changes on occasion.
 
If you assign the cell a range name you can refer to the cell by its name and
it won't matter what the worksheet name is.

Move the cell you want to reference and click INSERT on the menu, select
NAME from the drop-down menu and then DEFINE from the cascade menu. The
range name must start with a letter, it cannot have any spaces and the only
acceptable characters are the letters a to z, A to Z, or numbers or the
underscore.

By default range names are absolute references.

To use a named range in formula you can use the range name instead of the
cells addresses:

=SUM(MyNamedRange)
=A1*MyNamedRange
and so on...
 
Say you wanted to see cell C1.

Enter the name of the worksheet in A1, and try this formula:

=INDIRECT("'"&A1&"'!C1")

As you change the name in A1, you'll reference C1 in that particular sheet.
 
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

Excel VBA 1
formula error 1
Name a worksheet tab based on the value in a cell. 1
Dispaly results, rather than a formula 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I show the worksheet name in a cell? 3
Copy data from once worksheet to another using formula 2
Check multiple cells for a match 5

Back
Top