Matrix Dimension

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michelle - 24 Nov 2005 17:21 GMT

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 to this Message

Peo Sjoblom - 24 Nov 2005 17:45 GMT

You can use a dynamic range, define a name

=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),COUNTA($1:$1))

will work for a table that starts in A1 in Sheet1, do insert>name>define
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

Signature

Regards,

Peo Sjoblom

(No private emails please)

> 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 to this Message