Home
Forums
New posts
Search forums
Articles
Latest reviews
Search resources
Members
Current visitors
Newsgroups
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
range label works in VLOOKUP except if refenced in another cell
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
[QUOTE="brewmaker, post: 12901787"] I'm getting N/A message in VLOOKUP formula if I reference a range name in another cell. I setup the range name and formula correctly becuase it works when I enter the range name directly into the formula. For example: =VLOOKUP(G2,MS344,E2) returns the correct results. MS344 is my range name. The cells G2 & E2 feed values into the formula. =VLOOKUP(G2,F2,E2) returns #N/A. Cell F2 contains the range name MS344. I tried formatting cell F2 different ways and changing relative cell references to absolute references. Nothing works, suggestions appreciated. [/QUOTE]
Verification
Post reply
Home
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Worksheet Functions
range label works in VLOOKUP except if refenced in another cell
Top
