View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BorisS
 
Posts: n/a
Default 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