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.
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.
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
--
Regards,
Peo Sjoblom
(No private emails please)
"Michelle" <[email protected]> wrote in message
news:[email protected]...
> 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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks