dynamic range in formula

Posted on 2013-11-05
Medium Priority
Last Modified: 2015-03-02
I have a google spreadsheet.

If i specify the actual name of a named range in a formula, my formula works, see cell h11.  If i specify a cell that contains the name of a named range in the formula, it doesn't work, cell h12.

If someone could help me create a formula based upon a dynamic range, that would be great!!.

Please help me get my formula working.  thank you.
Question by:colonialiu20
  • 2
LVL 18

Accepted Solution

Steven Harris earned 2000 total points
ID: 39625342


Returns the reference specified by a text string. This function can also be used to return the area of a corresponding string. Reference is a reference to a cell or an area (in text form) for which to return the contents.

Author Closing Comment

ID: 39625531
quick response. perfect answer!
LVL 18

Expert Comment

by:Steven Harris
ID: 39625539
Happy to help!

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Whether you’re looking to gather data for research or gather feedback on an idea, being able to build and distribute your own online survey is not only cost-effective, but allows you to reach a larger audience and receive results in real-time. Googl…
Explore the encryption capabilities built into Google Apps and how these features can help you meet privacy policy and regulatory compliance, but are not a full solution. Understand and compare the most popular email encryption services for Google A…
This Micro Tutorial will introduce a Google tool, which is a great way to learn more about dimensions in metrics in Google Analytics, even if you use the interface or the API.
This Micro Tutorial demonstrates the importance of annotations in Google Analytics and how they should be used to document changes made to a site, Google updates (Ex: Panda & Penguin), marketing campaigns, and any other events that might have contri…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question