| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
named arrays in other workbooks
I have the following cell entry:
=INDEX(table,MATCH("value1",vert,0),MATCH("value2" ,horiz,0)) which returns the value of the intersection of value1 & value2 in an array named table, (vert and horiz are also named arrays). It is absolutely brilliant, but what I would like to do is look up named arrays in other workbooks. Can this be done?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) | |||
| How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
Linear Mode
