How to change a Table_Array size in a VLookup formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Define CHART (named range) as follows:

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

HTH
 
Back
Top