We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Range address

1r3o2n8
1r3o2n8 asked
on
Medium Priority
292 Views
Last Modified: 2012-06-27
I have a named range.  When I assign it to a formula, the address is displayed in the formula, not the range name.  Is there a way to correct this so that the descriptive range name appears in the formula.  See vlookujp formulae in attached workbook.  In the name manager, the cells have the proper notation.
RETAXES---Copy1-040211sendOnly.xlsm
Comment
Watch Question

Ardhendu SarangiSr. Project Manager
CERTIFIED EXPERT

Commented:
Hi
can you give some more information... your named range starts with A2 but the Vlookup uses range from A3. what named range would it be using?

Instead of selecting the range, just type the name of the range.  This should work.

=SUM(Sandesh)

This is how its coming for me.
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2011
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
CERTIFIED EXPERT
Top Expert 2008

Commented:
The problem is you defined your named range incorrectly. Don't enclose the range reference in quotes.

Kevin
CERTIFIED EXPERT
Top Expert 2008

Commented:
For example, Customer is defined as:

   ="a2:j20"

It should be:

   =a2:j20

Or even better:

   =Sheet1!a2:j20

Kevin

Author

Commented:
Thanks to all for quick response time. Rorya had just what I needed.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.