How to change a Table_Array size in a VLookup formula?

[Nickman]

If I have a Table_Array in a VLookup formula named, for example CHART and the
table named CHART encompasses cells A1 thru B10, How can I keep the name
CHART but expand it's Cells so it now encompasses A1 thru B20

 

[T. Valko]

Create a dynamic range. See this for instructions:

http://contextures.com/xlNames01.html#Dynamic

Biff

 

[Toppers]

Define CHART (named range) as follows:

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

HTH