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