vlookup on non-contiguous ranges
 

I've tried to name to non-contiguous (but similarly laid out horizontally)
ranges one name, and then use that name in a VLOOKUP. Won't work. Is there
an equivalent of this idea that does work? I am trying to find something in
one of two places, and then reference a cell off of that find.
--
Boris

vlookup on non-contiguous ranges
 

Hi Boris

Maybe if you name the ranges, range1 and range2 then use something like

=if(iserror(vlookup(value,range1,offset,0)),
if(iserror(vlookup(value,range2,offset,0)),"",
vlookup(value,range2,offset,0),
vlookup(value,range1,offset,0))

--
Regards

Roger Govier


"BorisS" wrote in message
...
I've tried to name to non-contiguous (but similarly laid out
horizontally)
ranges one name, and then use that name in a VLOOKUP. Won't work. Is
there
an equivalent of this idea that does work? I am trying to find
something in
one of two places, and then reference a cell off of that find.
--
Boris

vlookup on non-contiguous ranges
 

that's basically what I'd ended up doing in the interim of finding a
solution. Thanks for confirming that I was not missing a trick that would
have done it in one range name.
--
Boris


"Roger Govier" wrote:

Hi Boris

Maybe if you name the ranges, range1 and range2 then use something like

=if(iserror(vlookup(value,range1,offset,0)),
if(iserror(vlookup(value,range2,offset,0)),"",
vlookup(value,range2,offset,0),
vlookup(value,range1,offset,0))

--
Regards

Roger Govier


"BorisS" wrote in message
...
I've tried to name to non-contiguous (but similarly laid out
horizontally)
ranges one name, and then use that name in a VLOOKUP. Won't work. Is
there
an equivalent of this idea that does work? I am trying to find
something in
one of two places, and then reference a cell off of that find.
--
Boris