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
|