| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining arrays for a Lookup function
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup automatically specified arrays | Excel Worksheet Functions | |||
| Using text to lookup different table arrays in vlookup. | Excel Worksheet Functions | |||
| combining LOOKUP and IF functions | Excel Worksheet Functions | |||
| LOOKUP across multiple arrays | Excel Discussion (Misc queries) | |||
| Index, Lookup and Vectors/Arrays | Excel Worksheet Functions | |||
Threaded Mode
