How to change a Table_Array size in a VLookup formula?

N

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

Toppers

Define CHART (named range) as follows:

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

HTH
 
Top