View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nickman Nickman is offline
external usenet poster
 
Posts: 4
Default How to change a Table_Array size in a VLookup formula?

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