vlookup on non-contiguous ranges

B

BorisS

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.
 
R

Roger Govier

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))
 
B

BorisS

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.
 
Top