Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matrix Dimension
How do I change the range of data in a specific matrix, upon which other
lookup formulas are referring to. I keep getting "value" and "ref" errors. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matrix Dimension
You can use a dynamic range, define a name
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNT A($1:$1)) will work for a table that starts in A1 in Sheet1, do insertnamedefine put a name like MyMatrix there and use a formula like =VLOOKUP(A1,MyMatrix,2,0) as an example, more info here http://www.contextures.com/xlNames01.html#Dynamic -- Regards, Peo Sjoblom (No private emails please) "Michelle" wrote in message ... How do I change the range of data in a specific matrix, upon which other lookup formulas are referring to. I keep getting "value" and "ref" errors. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix calculation | Excel Discussion (Misc queries) | |||
How to identify entries in a matrix also present in another list | Excel Worksheet Functions | |||
Limits of MINV matrix function | Excel Worksheet Functions | |||
Recreate the upper part of a symetric data matrix 75x75 | Excel Discussion (Misc queries) | |||
Finding Values in a "Matrix" | Excel Discussion (Misc queries) |