| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
range label works in VLOOKUP except if refenced in another cell
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range label works in VLOOKUP except if refenced in another cell
Try it like this:
=VLOOKUP(G2,INDIRECT(F2),E2) If MS344 is a dynamic range defined with functions like OFFSET then the above won't work. -- Biff Microsoft Excel MVP "brewmaker" wrote in message ... 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range label works in VLOOKUP except if refenced in another cel
Yes, your advice worked. Many thanks!!
"T. Valko" wrote: Try it like this: =VLOOKUP(G2,INDIRECT(F2),E2) If MS344 is a dynamic range defined with functions like OFFSET then the above won't work. -- Biff Microsoft Excel MVP "brewmaker" wrote in message ... 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
range label works in VLOOKUP except if refenced in another cel
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "brewmaker" wrote in message ... Yes, your advice worked. Many thanks!! "T. Valko" wrote: Try it like this: =VLOOKUP(G2,INDIRECT(F2),E2) If MS344 is a dynamic range defined with functions like OFFSET then the above won't work. -- Biff Microsoft Excel MVP "brewmaker" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup almost works but not quite | Excel Discussion (Misc queries) | |||
| Dependant or Refenced Cells Calculations | Excel Discussion (Misc queries) | |||
| Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
| VLOOKUP works sometimes | Excel Worksheet Functions | |||
| Identify Label €” More than one cell with label | Excel Discussion (Misc queries) | |||
Hybrid Mode
