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. |
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. |
All times are GMT +1. The time now is 05:57 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com