• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 286
  • Last Modified:

Range address

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
0
1r3o2n8
Asked:
1r3o2n8
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
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?

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

=SUM(Sandesh)

This is how its coming for me.
0
 
Rory ArchibaldCommented:
The formula should be:
=VLOOKUP($A2,rgeCustomer,2,FALSE)
and so on.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
zorvek (Kevin Jones)ConsultantCommented:
The problem is you defined your named range incorrectly. Don't enclose the range reference in quotes.

Kevin
0
 
zorvek (Kevin Jones)ConsultantCommented:
For example, Customer is defined as:

   ="a2:j20"

It should be:

   =a2:j20

Or even better:

   =Sheet1!a2:j20

Kevin
0
 
1r3o2n8Author Commented:
Thanks to all for quick response time. Rorya had just what I needed.
0
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now