What would your lookup formula look like?

There is an add-in available that has a function that can do this but why
not just lookup as separate ranges?

--
Biff
Microsoft Excel MVP


"Blue Max" wrote in message
...
Is there a way to combine two named ranges, as if they were one, so it can
be used as an array argument in a lookup function? In other words, named
array-1 (A1:A5) combined with named array-2 (A10:A15) would become one
non-contiguous column (A1:A5, A10:A15) holding the continuous search
values for a LOOKUP function.