vlookup on non-contiguous ranges

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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