LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy a vlookup formula without changing the "table_array" p not 2 excell Excel Worksheet Functions 5 April 17th 23 07:03 PM
Vlookup with function in table_array JoshuaEyer Excel Worksheet Functions 2 October 15th 05 03:49 PM
VLOOKUP TABLE_ARRAY veljo Excel Worksheet Functions 6 April 1st 05 12:28 AM
mass change table_array Name in VLOOKUP formula GabbyU Excel Worksheet Functions 3 January 31st 05 09:31 AM
vlookup with table_array constructed from mid formula JulieD Excel Worksheet Functions 7 December 17th 04 06:22 AM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"